8 Replies Latest reply on Jan 29, 2018 7:34 AM by Joe Oppelt

    Conditional color formatting average payment term spend based on terms and dollar amount

    Matt Spicer

      I am trying to color format the highest three commodity spend with payment terms of N45 or below red (negative) and the highest two commodity spend with payment terms of N75 or higher green (good).  I am guessing this has to be done with some type of if and rank formula but I can't get the syntax to work.  I have named the calculated field "Color Format".