SUM all materials per warehouse

ThijsM — Fri, 05 Nov 2021 08:57:19 GMT

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

Re: SUM all materials per warehouse

MayilVahanan — Fri, 05 Nov 2021 09:58:32 GMT

Try like below

Sum(PRICE_PERPIECE*AMOUNTCORRECTIONS)

ThijsM — Fri, 05 Nov 2021 10:15:05 GMT

Thankyou!!!!!!