That is normal behavior when the number requires more space in the field to display as formatted. Try making the balance field enough longer for a couple of more characters.
Thanks for responding. The fields are more than wide enough to display the entire number. I even expanded the field to be twice the required length with exactly the same results as I originally described.
There is something else happening.
Any other ideas?
Is the field tall enough? Are there extra spaces at the end of the balances?
I have only seen this when the field is not big enough as well. Are you accounting for any formatting that includes decimals or currency symbols?
I did a test and a field with the value "60" needs to be about 6-7 characters (3.5x) to have it display "$60.00" properly without the "?".
I suppose you might really only need to a space for 4-5 extra characters if the numbers are bigger.
Use a Let in which you isolate the values of Get(RecordNumber) and GetNthRecord in separate locals, return those plus the final result separated by returns to see what really happens (I usually do that in DataViewer but it's only available if u have the advanced):
grn = Get(RecordNumber) - 1;
gnr = GetNthRecord (Balance; grn);
result1 = Case ( grn = 0; g BOP Balance; gnr );
result2 = result1 + Total Cash];
grn & ¶ & gnr & ¶ result1 & ¶ result2 )
In a found set of over 5000 records, the first 133 records display correct numbers, the next two records display "?" but will display the correct numbers only if clicked in. The rest display "?" no matter any clicking into the fields. I see the exact same results if I sort ascending or descending by date, so they are not the same records displaying the "?".
Based on this statement, I would assume something is wrong with either the Balance field or the Total Cash field. How are these defined? You might be having a dependency tree issue.
Another possibility is that there's some index corruption in the file, so it has trouble determining the previous and next records. You might try running a Recover and seeing if that turns up anything.
It is my guess that the running balance is too large for the field after the 133rd record.