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!