cancel
Showing results for 
Search instead for 
Did you mean: 

Mean of two key figures

Hi Team,

I wanted to take of mean of two KF into one KF

e.g

KF1=30

KF2=20

then KF3 should be

KF3 =30+20/2

=25

How we can do this?

Accepted Solutions (1)

Accepted Solutions (1)

manikandan_shanmugam3
Active Participant

I guess you wanted to check if KF3 has values (Stored) if so keep values in KF3 as it is otherwise ( KF1+KF2) / 2

You can achieve this through Stored and calculated KF.

TW09, there was no data for KF3 so it was calculated as 20+10 div 2 = 15 and TW10 had value 20 hence it had populated same.

Regards,

Mani

0 Kudos

Thanks Mani

Its working

Answers (2)

Answers (2)

manikandan_shanmugam3
Active Participant

KF3@ABC= IF(ISNULL("KF3@ABC"), (("KF1@ABC="+"KF2@ABC=")/2), "KF3@ABC")

yes, I think this is wrong calculation, you shouldn't use same KF in calculation.

the purpose of the calculated key figure is to calculate something on the fly. it cannot calculate ownself on the fly.

It will make senes only when your KF is both calculated and stored kf

Regards,

Mani


manikandan_shanmugam3
Active Participant

Hi Anil,

Create a calculated key figure and write calculation as per your logic. wondering what is challenging you in this simple logic? or are you missing to write something here?

K3 (@PLXYZ) = ( K1 (@PLXYZ) + K2 (@PLXYZ) )/ 2

Regards,

Mani

0 Kudos

Hi Mani,

Currently i m using below logic

KF3@REQUEST = AVG("KF3@ABC")


KF3@ABC= IF(ISNULL("KF3@ABC"), (("KF1@ABC="+"KF2@ABC=")/2), "KF3@ABC")


But its not working


m i missing someting?


Regards,

Anil