AnsweredAssumed Answered

No records found for unstored calculation

Question asked by RobS on Oct 12, 2018
Latest reply on Oct 12, 2018 by Fred(CH)

Hi there,


I'm having an issue finding values in an unstored calculation field.  This is an FMCloud-hosted file.


These represent the relevant fields:

Table 1::LenCalc1 = Length ( Table1::NumberField1 ) [indexed, result as number]

Table 2::LenCalc2 = Length ( Table3::NumberField2 ) [related/portal values so unstored, result as number]

Table 1::DiffCalc = Table 1::LenCalc1 - Table 2::LenCalc2 [different table so unstored, result as number]


Essentially DiffCalc should ideally always be 0, but where it's not, it should be flagged.  I want to check that this works, so I deleted the NumberField1 value in a single record (as this is representative of the main potential issue to be flagged) and the DiffCalc is now showing -1; all other records show 0 (as expected).


However, if I search in DiffCalc for 0 or <0 or -1 it can't find any records.  Strangely this find did work for a while (about 10 searches) and then stopped working altogether.  I suspect this has something to do with both DiffCalc and LenCalc2 being unstored, but is there a way to make this work?


Thanks for your time.