Calculation Type E for Key Figures in Planning Book

[alok_jaiswal]

Hi All,

We have a key figure where calculation Type = 'E'  (Average of All Details Not Equal to Zero) is used.

When we enter value of say 100 at aggregate level, same value 100 is disaggregated at detail level. However, when we are chaging value at detail level, values are getting changed in different manner) - Below is the scenario

Value is 100 at Detailed level  - On drill down by region, could see value of 100 in all the four regions. On changing value from 100 to 200 for one of the regions and saving could see value at total level chaging to 125 which is as expected (200+100+100+100=500/4= 125). However if i then select Region at total level(Drill up on Region) - value is getting changed to 154 whereas I expected it to remain at 125. Why is this happening?

We do not have any macros running in the planning book/data view so can rule out the macros.

Please help understand this behavior.

Regards,

Alok

[alok_jaiswal · Accepted solution]

To add to this, the issue was resolved and below is the explanation for the same -

At initial load when we have no navigation path defined, value is calculated from the values of the lowest level members.

In SDP94, I executed the drill down to reach the lowest level and after calculating the average of all non-zero values of key-figure, was getting the correct number as shown in planning book.

So, basically key-figure values are stored at the lowest level and path used for aggregation/dis-aggregation is dynamic and its created at run-time depending on the navigation path.

Regards,

Alok

[former_member225716]

Dear Alok,

For any Average key figure, before calculation it is recommended that, you should reset at aggregate level and then recalculate it.

In my previous reply I mentioned at detailed level.

Please try with this option

Regards,

Sachin

[former_member187488]

Hi, how many CVCs are included in the selection? Is it possible for you to list down all the characteristics and CVCs ?

[jagannadhb]

Hi Alok,

Adding to Ada's reply, check if the region you are drilling up to, has the same CVCs that you are using for the drill down... means, does the selection have more CVCs than what you have drilled down to?

Regards

JB

[alok_jaiswal]

Hi JB,

Volume of CVCs is same at both total and detailed level - there is no change in that.

Regards,

Alok

[former_member225716]

Dear Alok,

Before changing the values at detailed level, You first Reset the KF and then try.

Regards,

Sachin

[alok_jaiswal]

Hi Sachin,

Even after resetting the key figure and then entering the values at Detail level, could still see values are getting changed when I am drilling up - at total level.

Regards,

Alok