numer of pallets in pending orders

[MichaelFL]

Hello ,
i would like to create a simple table to view the no. of pallets in the future goods receipts.
To sum or to count the pallets is clear but I think in this regard we have to consider one more thing to get the right output.
For example on one pallet are 100 units. The supplier deliver 500 units. Than it is clear 5 pallets.
But how can I change the formula that I consider also partial shipments. Can I do this with aggr func?
Variable data:
PO pos 1. Article 1 with 80 units
PO pos 2 article 2 with 20 units.
Output should be 2 pallets not 1.

Hope I have describe my problem clearly enough...

[usamabinsadiq]

Hi,

please provide sample data in excel to work with, 

thanks

[MichaelFL]

The correct no of pallets is 9. When you sum QTY and divide with 100 is 8. And 8 is not correct

[usamabinsadiq · Accepted solution]

Hi,

please see the result, I think this is what you were looking for

here is the Measure Expression:

Sum(ceil(QTY/100))

hope this helps,

Regards,