10 Replies Latest reply: Dec 18, 2017 8:05 AM by Jarrad Murray RSS

    Display sum of calculated column in each cell of column

    Jarrad Murray

      Hi All,


      I am having a little trouble getting the sum value of a field and am hoping someone may have come across something similar.


      I have a pivot table that has a number of calculated fields (each feeding off the previous).  I am trying to create a new column that sums the values of one column if they are not negative numbers.


      I have managed to show the positive values and turn all negative ones to 0 through an if statement but the expression total still shows the value as if the negative values remain (1st column).


      The statement I am using is as follows


      if(Code = '06T', sum({<Code2 -= {'INCOM92%'}>} [<18]),

      sum({<Code2 -= {'INCOM92%'}>}[<18])*max(Excl06T)) < 0, 0,


      if(Code = '06T', sum({<Code2 -= {'INCOM92%'}>} [<18]),

      sum({<Code2 -= {'INCOM92%'}>}[<18])*max(Excl06T)))


      Is there a way that I can get the total value of only the positive values to be shown in the column for each row (so 1389.88 in each cell)


      Any help you can offer is greatly appreciated.