Create a customer product mix calculation key figure

[Former Member]

Hi Experts,

Objective: Create a customer product mix calculation key figure

Step 1: Created a planning level PERCUST

Step 2: Added a calculation level in CONSENSUSDEMAND key figure (CONSENSUSDEMAND@PERCUST = SUM("CONSENSUSDEMAND@PERPRODCUST)

Step 3: Created a key figure with calculation ZKFCUSTPRODMIX@PERPRODCUST = "CONSENSUSDEMAND@PERPRODCUST"  / SUM( "

CONSENSUSDEMAND@PERCUST" )

It returns the following error "The planning level used for the output key figure should be a subset of the input planning level."

Any alternate way of doing this?

Regards,

Aditya G

[Former Member · Accepted solution]

Rearranging the math?

KFx@PERPRODCUST = KFy@PERPRODCUST * (1/sum(KFy@PERCUST))

[Former Member · Accepted solution]

Hi,

YS - I tried that but while validating the syntax, "CONSENSUSDEMAND@PERCUST" becomes "CONSENSUSDEMAND@PERPRODCUST"

JJ Watson - Same result, it makes the calculation look like "CONSENSUSDEMAND@PERPRODCUST" * (1 / SUM("CONSENSUSDEMAND@PERPRODCUST"))

Regards,

Aditya G

[yeushengteo · Accepted solution]

Ok, can you try using a different calculated KF or a helper KF to represent the

"NEW_KF@PERCUST" = SUM("CONSENSUSDEMAND@PERPRODCUST)

Later use the new KF for the step 3 calculation definition.

Regards.

YS

[Former Member · Accepted solution]

Hi YS,

Helper key figure worked. Thanks.

Regards,

Aditya G

[yeushengteo]

Hello

In your step 3, it should be as follow? You have a SUM() earlier..

"ZKFCUSTPRODMIX@PERPRODCUST" = "CONSENSUSDEMAND@PERPRODCUST" / "CONSENSUSDEMAND@PERCUST"

Regards.

YS