Custom key figure at PERPRODLOC level using helper key figure at PERPRODLOCLOCFR level

[Former Member]

Hi Experts,

Need your guidance when creating a custom key figure.

We have created a custom key figure "composite fat" at PERPRODLOC level which is referring a helper key figure that is multiplying two key figures at PERPRODLOCLOCFR level

The intention is to have "Composite fat" key figure calculation to be PERPRODLOCLOCFR level (through helper key figure) and projection only at PERPRODLOC level. Screenshots of the definitions attached.

Issue: In excel UI we can see "Composite fat" key figure at PERPRODLOCLOCFR level

Please guide as to how we can restrict projection of "Composite fat" key figure to PERPRODLOC but calculate at PERPRODLOCLOCFR level.

Thanks.

[Former Member]

Hi,

We cracked this issue, the problem was with "composite fat" key figure being checked as stored.

Attached is the modified definition.

Regards,

Aditya G