Aggregation of Key Figure when its based on multiplication of two different KF

[former_member367912]

Can you help on the below requirement:

KF1 has base planning Level DAYPRODLOC

KF2 has base planning Level DAYPRODLOC

KF3 has base planning Level DAYPRODLOC

KF3 = KF1 *KF2

Data in KF1 and KF2 exists as

Now when we are viewing the KF3 in excel planning view at Day level we should get below output

Now when we are viewing the KF3 in excel planning view at WEEK level we should get below output which is (7*2) *(4*7)

[Saisamrat · Accepted solution]

Hello Akhilesh,

If you want same logic at across all time hierarchy levels also then define calculation in KF3 at request level as below

KF3@Request = KF1@Request * KF2@Request

Make sure KF1 and KF2 aggregation modes are SUM.

Let me know outcome once you try above calculation.

Regards

Sai Samrat

[ankpatel · Accepted solution]

Akhilesh, a suggestion provided by Sai should work.

[former_member367912 · Accepted solution]

Awsome Guys.. Thanks!!

This is precisely what I was looking for.

Regards,

Akhilesh