1 Reply Latest reply: Dec 5, 2017 9:52 AM by Sunny Talwar RSS

    Target vs Actual percentage

    Wim Rijken

      I want to show target vs actual in a pivot table.

      I have 2 tables: 1 with actuals, 1 with the targets (target margin %, target amount)

      I combine these in a fact-table.






      Target margin pct



      Now I want to show Actual and KPI next to each other based on the dimension "TargetActual" in 1 expression

      The problem is that the calculation for the actual margin (amount-cost)/amount is NULL.

      So it does not show a pct value.


      see example attached.


      What is the solution for this?