6 Replies Latest reply on Oct 8, 2018 12:13 AM by Stephanie Gessler

    Adding four different calculation together

    Stephanie  Gessler

      Dear all,

      I used four different calculation to split the KPI and I cannot add them together. As you can see the first KPI Demand&FCF1 NEW is empty. I do not know why.

      Every KPI is a different caculation and I cannot add them together when I needed to split them. Please help!

       

      The KPIs are based on the following calculations

       

      Demand-1

      IF

      MONTH <= dateadd('month',-2,today())

      then [Demand]

      ELSE NULL

      END

       

      FCF1-1month

       

      IF MONTH=MONTH(TODAY())-1 AND

      YEAR=YEAR(TODAY())

      THEN [FCF1]

      END

       

      Future FCF1

      IF DATEMONTH>=TODAY()

      THEN FCF1

      ELSE NULL END