Skip to Content
0
Mar 18, 2009 at 07:02 AM

Problem in planning function

35 Views

Scenario :

In our report we need to populate the data for four seasons, SS09, SS10,SS11,SS12.

The structure of the report will be like:

Season Brand DU Growth% Vol ActualGP

SS09 Adi BB 0 500 0

SS10 Adi BB 0 500 0

SS11 Adi BB 0 500 0

SS12 Adi BB 0 500 0

After applying Growth% of 100 for SS09 the new volume will be 500 + (100*500/100) = 1000.

This volume needs to copied into Vol keyfigure of SS10 i.e Vol of SS10(before applying Growth%) should be equal to vol of SS09.

After applying Growth% on SS10 Vol, that volume needs to copied for SS11 Vol.

After applying Growth% on SS11 Vol, that volume needs to copied for SS12 Vol.

Everytime we enter the Growth Percentage in Growth% keyfigure , That value will transfred to the ActualGP and Growth% keyfigure becomes 0.

Problem:

we are able to copy the data from SS09 to SS10 and SS10 to SS11.

After applying Growth% on SS11 Vol and click on Transfer again SS10 Volume is replaced with SS09 Vol.

But this shouldn't happen.