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.

      [

      TargetActual

      Product

      Amount

      Cost

      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?