Column calculations

[john9210]

I’m using FM 8 and Win Vista. I’m having troubles column calculations. I’m using GetSummary fields instead of Summary fields so I can do the calculations. The fields are located in a sub-summary part. See Attachment for screen shot of layout and browse modes

I have three columns of data, D. E and F.

Column D uses a GetSummary field to calculate values, and Column E uses a GetSummary field to calculate values. Both show correct results.

In column F, I’m trying to subtract Column D from Column E with a GetSummary field . It simply subtracts the D and E GetSummary fields. The results are all correct except for the very first value in the column. This seems strange. What could be causing this? I don’t know where to look.

Screen_shots.pdf

[John Mark Osborne]

My guess is you are formatting your numbers using the Number format option. This feature only formats the number for display. For instance, if you have a number like 25.369 and format it to display only two decimal points so it appears as 25.36, the original value is still used when performing a calculation (try clicking into the field to see the real number behind the formatting). If you want to work with the formatted number, try using the Round function in your calculation formula.

[comment]

The difference seems too large to be a result of rounding.

The results are all correct except for the very first value in the column

The total of column F seems to be way off too. I think we need to see the exact calculations being used - why don't you attach a file showing the problem?