? displayed instead of value in an ongoing calculation referring to a previous dataset
I'm confronted with an odd problem which only shows now not that the database has grown in size. I used a calculation to display a value of a previous dataset from my line items. The calculation worked fine, but now that I have a bit more than a year data in the database, Filemaker suddenly shows a '?' instead of the calculated value. I provided a screenshot for as well as details to the calculation. Can anyone help? Thanks a lot!
- If I manually click into the field with a '?', Filemaker displays the correctly calculated value. This means, that the calculation is correct.
- I do not want to work with a number field (instead of calculation), as it is impractical to re-calculate the value every time a user changes a number (takes about 6-7 seconds with the script)