Calculation of previous record results in "?" on and after the 29th record on Filemaker Go
Not sure how to get it.
Operating system version
Description of the issue
The calculation sequence or formula shown below works well in Macbook Pro. But when the file is transferred into FILEMAKER GO, it produces question marks after the 28th record.
I know this was already raised before but I could not find any answer. Please help.
Steps to reproduce the problem
This is the calculation sequence i tested in my Mcbook Pro.
For example, creating a running balance calculation based on obtaining balance from previous record using GetNthRecord - 1, fails to display a value after 29 records. Steps to Reproduce:
. Create a database file with the following fields: Miles (Number) Starting Balance (Number) Ending Balance (Calculation Number Unstored = Starting Balance + Miles)
. Change Starting Balance from Number to Calculation (Number, unstored) with the formula: If ( Get (RecordNumber) = 1 ; 0 ; GetNthRecord ( Ending Balance ; Get ( RecordNumber) - 1 ) )
. In Browse Mode, add one record and enter “1” into Miles.
. Duplicate the record 40 times.
. Transfer the file to Filemaker Go via email.
. Launch FileMaker Go, open the file, and look at record 29 and record 30.
Record 29 and thereafter should have correct values in the Starting Balance and Ending Balance
Question marks, "?", at record 29th onwards for Starting Balance and Ending Balance.
Exact text of any error message(s) that appear
Just the sign "?"
Not that I know of