AnsweredAssumed Answered

Calculation of previous record results in "?" on and after the 29th record on Filemaker Go

Question asked by ManuelJrMendoza on Sep 21, 2013
Latest reply on Oct 7, 2013 by philmodjunk

Summary

Calculation of previous record results in "?" on and after the 29th record on Filemaker Go

Product

FileMaker Go

Version

Not sure how to get it.

Operating system version

iOS 7.0

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.

Expected result

Record 29 and thereafter should have correct values in the Starting Balance and Ending Balance

Actual result


Question marks, "?", at record 29th onwards for Starting Balance and Ending Balance.

Exact text of any error message(s) that appear

Just the sign "?"

Configuration information

Not that I know of

Workaround

None

Outcomes