6 Replies Latest reply: May 23, 2018 7:56 AM by Markus Blaut RSS

    pivot formula does not work

    Markus Blaut

      Hi people,


      I have calculated an KPI with the following formula:


      (rangesum(above(sum([IstAEzuFP 2018]),0,RowNo())))


      Sum(Aggr(If(Sum([IstAEzuFP 2018]) > 0, Sum([BudgetzuFP 2018])),AccountingMonth))


      So the formula perfectly works in the KPI.


      But if I put the formula in an Pivot table to distinguish between products it does not work at all:



      Does anyone has an idea how I can make the formula work also in the pivot!?


      Tank you!