Summary report total error?

Question

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 total amount is negative it should be a "Credit". The issue I am having is some totals are summing to "-0.00" registering as a credit, and some totals are correctly summing to 0.00 as "Closed". How can i fix this?

MarkShnierYou · Answer

You 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)

Sign up

Login to the community