Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculated keyfigure

Hi all!

I try to do what I thougt was a simple thing.

I have following keyfigures:

Quantity | Weight | Quantity*Weight | Weight2

100 pc | 1 | 100 | (100 / 130 not 100/260!!!)

100 pc | 0,3 | 30 | (30/130 not 30/260!!!)

Result row will then be:

200 pc | 1,3 | 260 |

In keyfigure Weight2, I would like to take the result of "quantityweight"-keyfigure for that row and share it with the result of the summation of the keyfigure "quantityweight". The problem is that I would not like to share it with the result of 260 but the real result that I get if I do a summation of the keyfigure (130).

How can I do that? If I use the "calculate result as"-summation, the result will be right but thats just for the display. My weight2 keyfigure will still use 260.

The formula for weight2 is:

'Quantity * weight' / SUMRT 'Quantity * weight'

All answers are welcome...

BR

Morgan

Not what you were looking for? View more on this topic or Ask a question