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.