Cost breakdows upon items

1

Hi,

I would like to break down a total cost upon items
For example I have a total of 10 M€ to distribute upon 3 items base on volumes.
ITEM VOLUME
A 100
B 400
C 500

The expected result is :
ITEM VOLUME EXPECTED AMOUNT M€
A 100 1
B 400 4
C 500 5

100 /(100 + 400 + 500) * 10 M€ = 1 M€

Is there a better way than a derive table to calculate this ?

Best.
Michel

2

Hi Michel,

there is no dedicated total breakdown transformation. Such calculation should be arranged using a derived table and the Peek transformation.