Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Try like below
Sum(PRICE_PERPIECE*AMOUNTCORRECTIONS)
HI
Try like below
Sum(PRICE_PERPIECE*AMOUNTCORRECTIONS)
Thankyou!!!!!!