SUM all materials per warehouse

[ThijsM]

I want to SUM all the materials corrections in euro's for every warehouse.

I tried:  PRICE_PERPIECE*Sum(AMOUNTCORRECTIONS) on material level and it works perfectly fine,

But on warehouse level the calculations won't succeed.

For instance a warehouse has 2 materials.

Warehouse 1:

Material 1:

AMOUNTCORRECTIONS = 2 pieces

PRICE_PERPIECE               = 6 euro's

TOTAL 12 euro's

Material 2:

AMOUNTCORRECTIONS = 2 pieces

PRICE_PERPIECE               = 100 euro's

TOTAL 200 euro's

I want to sum per  warehouse and get for instance 212 euro for warehouse 1

[MayilVahanan · Accepted solution]

HI

Try like below

Sum(PRICE_PERPIECE*AMOUNTCORRECTIONS)

[ThijsM]

Thankyou!!!!!!