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