6 Replies Latest reply on Oct 8, 2018 12:13 AM by 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. The KPIs are based on the following calculations

Demand-1

IF

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

• 1. Re: Adding four different calculation together

We need a workbook and your expectation on what is to be added.

• 2. Re: Adding four different calculation together

Hi  Stephanie,

You have listed the calculation for 3 KPIs except 'Demand&FCF1 NEW', can you share the calculation for this specific KPI.

Or is it the sum of other 3 KPIs?

Regards,

BKN

• 3. Re: Adding four different calculation together

I published my workbook online, I hope you can access it.

I needed to remove some data and the names changes slightly but overall the logic is the same:

In this example I added the KPIs together

[Demand-1]+[FCF-1month]+[Future FCF1]

• 4. Re: Adding four different calculation together

Hi Stephanie,

Can you try updating your formula for - "Demand&FCF1 NEW" with this :

IFNULL([Demand-1],0)+IFNULL([FCF1-1month],0)+IFNULL([Future FCF1],0) Regards,

BKN

• 5. Re: Adding four different calculation together

Hello,

You can wrap the calculation with "ZN". The value was coming as blank because for a year, you were not having data  for both the measures. Like when data is there in 1st measure then 2nd measure is null and vice-versa.

SO adding of any value with null is null, that's why blank value.

• 6. Re: Adding four different calculation together

Thank you so much. This helped me a lot to add them both :-)

Thank you so much for your support!