AnsweredAssumed Answered

How to set calculation field as stored?

Question asked by brett_ on May 28, 2011
Latest reply on May 28, 2011 by brett_

Title

How to set calculation field as stored?

Post

I have a calculation field, GHivsPrevClose, that uses the following calculation:

GHi - table2::Close Price

GHi is just a number and not calculated.  Its indexing is set as None with automatically create indexes as needed.  table2 is a self join on table1.  Close Price is also a non calculated number field and indexed.  

I keep getting this error when I try to uncheck "Do not store calculation results..."

The calculation “GHivsPrevClose” cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with global storage.

I cannot see where FM is having an issue with this field.  Is there a way to force FM Advanced to show which field it is referring to?

Outcomes