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
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Try this as a row colorization formula on on a table report type.
IF([total cost] <> [total line item amount], "pink")
or the word yellow works works nicely too for a color.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Try this as a row colorization formula on on a table report type.
IF([total cost] <> [total line item amount], "pink")
or the word yellow works works nicely too for a color.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you!
I tried the formula and it did highlight the correct rows but it also highlighted rows where total cost=total line item amount. Any idea why?
------------------------------
Sophie A Primeaux
------------------------------
I tried the formula and it did highlight the correct rows but it also highlighted rows where total cost=total line item amount. Any idea why?
------------------------------
Sophie A Primeaux
------------------------------
- MarkShnier__YouI 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
------------------------------- Yes that was it! Thank you!
------------------------------
Sophie A Primeaux
------------------------------