I have created a report in an adp based on a query of a settlements table i have in my database. The field i am having trouble with is a calculated fields sum dropping cents. The field is Negotiators ...

Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes. You’ve created a query that calculates an invoice total by adding the order total and the ...