How to set calculation field as stored?
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?