Sum of key figure issue

[Former Member]

Hi,

I have am issue with a sum of kf, the scenario is as follows...

char        col A   col B  col C
------        --------   -------  -------
aaa           100       20       5
aaa             50        2      25
total aaa    150       22       6.18

As you can see the kf col C is a calculated kf col C = col A / col B, we need that the total must be 30 not 6.18... i tried with virtual kf with the same result...

Any clues please

TIA

Best Regards

[Former Member]

Col C = NOERR(ColA / ColB)

Then right click on "Col C" to change properties to = calculate RESULT as "summation" inside the Bex Designer

If the first column shown in your example is a "structure on the rows" that adds the items to get to the total... then there would be 2 property settings for Col C:

- calculate result = summation ... and...

- Formula Collision = Result from competing Formula

Edited by: Sharon West on Dec 4, 2008 2:39 PM

[former_member207028]

HI,

Right Click on Calculated Keyfigure and select calculated result as "Summation"

hope this solves problem

Regards

Daya Sagar

[Former Member]

Hi Juan,

Select the 'Col c' KF properties and select the calculations tab, and pick 'Total' in Calculate Results As...

Let me know if this worked?

Regards,

Hima

[Former Member]

Thanks Hima, but it not works

Best Regards...

Juan

[ssurampally]

Hi Juan

If your Calculated Key Fig is Using another Calculated Keyfig in that, Before Aggregation option would be disabled. if it is the case then you can specify the earlier calculation and the current in only one Calculated key Fig, then you will n't have this problem.

Regards

Sreekanth

[Former Member]

Thanks Sreekanth,

But this is not the case... my calculated kf no have another calculated key figure..

Best Regards

Juan

[Former Member]

in the properties just say calculate result as Summation

[Former Member]

Thanks but this is the first thing we tried... and doesnt works

Best Regards

Juan

[Former Member]

Sorry but i forgot to metion that the sum not work when we selected view as hierarchy, it works pretty well in view as lines.

Best Regards

Juan

[ssurampally]

Hi,

calculated Key fig - Right click - Properties - Give Before Aggregation at the Aggregation text box.

[Former Member]

Thanks Sreekanth S but i cant select Before Aggregation its appears greyed...

Thanks In advance

Best Regards

Juan

[Former Member]

Use the cell reference to add them