4 Replies Latest reply: Sep 11, 2014 2:06 AM by Nicola Perrone RSS

    Setting background color in a straight table

    Nicola Perrone



      I'd like to set a particular background color in a straight table when a value in a specific columns is equivalent to the max of the values of the same column.


      The value of the colums is calculate as Sum(Price) and the columns name is "Prices"


      I set the background color function as follow:

      IF([Prices]=Max(TOTAL Sum(Price)),Green())


      but it doesn't work; the max function is wrong 'cause if i change the function as follow:


      it works properly.


      Should someone help me with the max function, pls?


      Thank you.