Data distribution in formula key figure with reference to a selection

[Former Member]

Hi All,

I got stuck with one issue may be anyone of you can help :

I have a formula key figure and a selection key figure.

Now in the query the selection key figure value comes from another query where it is planned.

The user wants the Formula key figure values getting distributed according to the selection key figure values.

Suppose I have the data in the first query as:

DEV location	formula KF	selection KF
A	100	80
B	10	90
C	30	70
D	40	20
E	50	100

and the second query as :

DEV location	selection KF
A	80
B	90
C	70
D	20
E	100

Now I change the value of Selection KF value of DEV location B to 30 .

And the value in the formula KF should get distributed according to the reference of Selection KF.

Automatically it should happen , we should not have the logic of disaggregation.

Thanks ,

Ayushi

[Former Member]

Hi Ayushi,

I am assuming that that formula key figure is getting calculated based on input from selection key figure. In this case value will change as soon as you make any adjustment in selection key figure.

If you are changing value at aggregated level for selection KF, you need to define a disaggregation logic(proportional or copy value) to propagate the value at base level and same can be taken as input to formula key figure which will be further aggregated at request level based on aggregation mode(sum, avg etc).

Thanks,

Rohit

[Irmi_Kuntze]

Can you provide screenshot / formula of what you made? Would make reply more easy