1 Reply Latest reply: Oct 29, 2016 4:02 AM by Shraddha Gajare RSS

    Red and green color percentage table

    Arne Kanters

      Hi

       

      How can I create red color for negative % and green for positive % in following table? Can't seem to manage with proper formula under background formula expression. Thanks

       

      The underlying formulas for V (Volume) and VpM (Volume previous month) are as follows:

       

      V: Sum([#Quantity])

      VpM: sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])

      %CH: Sum([#Quantity]) / sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])-1

       

       

      perc2.JPG