6 Replies Latest reply: Feb 28, 2011 6:43 AM by Ashwin Pagare RSS

    Error total sum field calculated

      Dear all,

       

      I have a problem with a pivot table

       

      I have 3 fields and I want to add like this:

       

      if(sum(Field 1)+Sum(Field 3) > Sum(field 2),sum(Field 1)+Sum(Field 3),Sum(field 2))

       

      It work for dimensionality()=6 but for dimensionality()=1 it gets the greater of Sum(Field 1) + Sum(Field 3) or Sum(field 2) and not the sum of the values.

       

      What can i do?

       

      Best regards