cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Key Figure Data

advait1998
Explorer
0 Kudos
270

I want to copy values in KF2 - (W01-5) and (W02-5), in KF1 (W01) & (W02) without affecting the value in

KF1 (W03-10).

Accepted Solutions (0)

Answers (1)

Answers (1)

riyazahmed_ca2
Contributor
0 Kudos

Hi Advait,

Make KF1 as Stored and Calculated KF.

KF1@REQUEST = SUM("KF1@PL") --> Go into Input and select the KF1@PL as Calculated.

KF1@PL = IF(ISNULL("KF1@PL"), "KF2@PL", "KF1@PL") --> Go into Input and select the KF1@PL as Stored

Let me know for any issues or further queries.

Best Regards,

Riyaz

advait1998
Explorer
0 Kudos

Hi Riyazahmed,

Thank you for your response.

I have maintained calculation as you have explained.

Can you please explain me which key figure should be stored and which should be calculated in both of the calculations in above screenshot. As you mentioned, I selected for 'REQUEST' calculation, Input as calculated and for 'WEEKPRODLOC' as stored for both key figures as in below screenshots.

advait1998
Explorer
0 Kudos

Screenshot of Inputs for WEEKPRODLOC:

riyazahmed_ca2
Contributor
0 Kudos

advait1998 calculation looks perfect. Go ahead and check

advait1998
Explorer
0 Kudos

Thank You Riyazahmed for your help and support. It is working fine now.