Need calculation for average of 2 key figures in 1 Key figure in IBP

[reddyatoz]

Hi Experts,

I am trying to calculate the average of 2KF's(KF1 and KF2) and display the result in 3rd KF(KF3). ALL KF's are in same level.

And if any KF value is blank(KF1-AUG and KF2-JUN) this should be replaced by null or "0".

For this i need Calculation expression in IBP.

Thanks in advance

Regards

Kiran

[AyanBishnu]

Hi reddyatoz

Please follow the steps below to get the desired output

• Create a helper KF (e.g HKF1@PL) HKF1@PL = IF(ISNULL(KF1@PL),0,KF1@PL)
• Create another helper KF (e.g HKF2@PL) HKF2@PL = IF(ISNULL(KF2@PL),0,KF2@PL)
• In KF3@PL = IF(HKF1@PL <= 0 AND HKF2@PL <= 0, NULL,(HKF1@PL + HKF2@PL) / 2)

RegardsAyan