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...