Mean of two key figures

[former_member657407]

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?

[manikandan_shanmugam3 · Accepted solution]

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

[former_member657407 · Accepted solution]

Thanks Mani

Its working

[manikandan_shanmugam3]

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]

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

[former_member657407]

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