New Key figure on Product level

[reddyatoz]

Hi Experts,

I need Key figure logic in IBP for below issue.

The new key figure should be called 'Number of Planning Files'

I would like the key figure on product level calculating the number of Product Location combinations where a single Product has a value in the 'Planner' attribute.

[rahulmohnot]

Hi Kumar,

you will have to break this calculation in 2 key figure.

KF1@MTHPROD= if("Attribute"=' '<value>' ',1,0)

KF2@MTHPROD= Count("KF1@MTHPROD")

OR

if you want in one KF then

KF1@MTHPROD= if("Attribute"=' '<value>' ',1,0)

KF1@REQUEST=COUNT("KF1@MTHPROD")

Hope this helps.

-Rahul

[former_member804657]

Hi Kumar,

You can explore the count function. However, It will only count the number of Product-Location combinations that existed in the particular month and sum up to Product level. I'm afraid giving the consideration to the 'Planner' attribute is still not supported.

More details in this link: COUNT | SAP Help Portal

Hope this helps.

Sittinut