Forum Discussion

Sophie_APrimeau's avatar
Sophie_APrimeau
Qrew Trainee
5 years ago

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] (this is a summary field).

I attempted to write a formula but it's highlighting the wrong rows. I do not have any coding experience so I'm struggling.

THANK YOU!!

#formula ​​

------------------------------
Sophie A Primeaux
------------------------------
formula

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np,
    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
    ------------------------------
    • Sophie_APrimeau's avatar
      Sophie_APrimeau
      Qrew Trainee
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        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
        ------------------------------