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

    Setting background color in a straight table

    Nicola Perrone

      Hi,

       

      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:

      IF([Prices]>10,Green())

      it works properly.

       

      Should someone help me with the max function, pls?

       

      Thank you.

       

      N.