My question is on how to ensure that a plain number field (CountCasesResult) is displaying the result of a calculated field (CountCasesCalc ) whenever changes occur to that calculated field - automatically. I'm trying to speed up a list-based summary report that I created with the help of Matt-squared (Matt Navarre, Matt Petrowsky).
I was manually running a replace command, but ended up creating a new calculated field, which is becoming a real drag.
I'd like this to be automatic, like FileMaker's indexing of fields for calculation purposes.
Currently, I have a self-join in the data file, along with these 3 fields:
CountCasesCalc - count of "case id" within the chosen analysis for the selected issue
uniqueCasesCalc - count of unique cases on a selected issue
CountCasesResult - Just a number field to hold the result.
I also tried this as auto-enter, like my HostTimeStamp, but it is not updating when the referenced calc (CountCasesCalc) changes:
~trigger = CountCasesCalc ; Case ( uniqueCasesCalc > 0 and CountCasesResult ≠ CountCasesCalc ; CountCasesCalc ; CountCasesResult )
The report seems much faster with the number field result compared to the unstored calculation I have now.
Does this require a trigger in the data file? Am I looking for the impossible? Any suggestions will be very welcome.
Thanks in advance.
- - Scott