AnsweredAssumed Answered

Calculation field with GetNthRecord to previous value doesn't work

Question asked by malauch on Jan 4, 2018
Latest reply on Jan 4, 2018 by TSGal

Product: FileMaker Pro 16 Advanced

OS: MacOS High Sierra 10.13.2

Hardware: iMac 5k 2017

 

I have problem that recursive (I don't know if it's correct English name for it) field calculation is working for first 139 record but after that it displays only "?".

 

Very simple example:

Field calculation definition:

Case ( 
Get ( RecordNumber ) = 1; 0;
GetNthRecord ( Data::Value ; Get ( RecordNumber ) - 1 ) + 1
 )

 

Expected result:

0

1

2

3

4

...

200

 

For first 139 records it's works exactly like that but after that it just display error "?".

 

Result:

0

1

3

4

...

138

139

?

?

?

...

 

I attache sample file.

 

Problem occurs when calculation is unstored. For stored calculation It works just fine.

Attachments

Outcomes