Simple formula help
Hi, I am trying to write a formula to color code my report. Basically what needs to happen is that the row is highlighted if the field [total cost] does not equal the field [total line item amount]...
Forum Discussion
I suspect that there are some rounding issues and the summary total does not equal the value on the record.
Try this
IF(Round([total cost],0.01) <> Round([total line item amount], 0.01), "pink")
That will round both to the nearest penny. Does that work?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Try this
IF(Round([total cost],0.01) <> Round([total line item amount], 0.01), "pink")
That will round both to the nearest penny. Does that work?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Yes that was it! Thank you!
------------------------------
Sophie A Primeaux
------------------------------
------------------------------
Sophie A Primeaux
------------------------------
