Summary report total error?
In an AR tool i am developing, I am calculating the amount owed for a project. If the total is positive for the amount column, it should be "Open", if the total is 0 it should be "closed", and if the...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou have a couple of choices here. No doubt the underlying data has more than two decimals in the actual calculations. In other words, some decimals beyond the nearest Penny. So you could round that calculation before doing the summary field. The alternative is to make a new field on the parent table which round the summary field total to the nearest Penny.
round([my field], 0.01)