Aggregate ceiled rows

[#1]

I have a table with the following dimensions:

* Article

* Receipt date

* # pcs

* # pcs per pallet

And the following calculated expression

* (ceil(sum(# pcs/ # pcs per pallet) to calculate the rounded # pallets to be received.

This works fine, but in another table I want to calculate the same, but summed per date:

Dimension:

* Receipt date

And the same following calculated expression, but then aggregated as in the first table. Otherwise the total # pallets is calculated over the (total #pcs/total #pcs per pallet) - here you will get a lower number of pallets.

How can I use the agg and the ceil?

[#2]

See example

[Gysbert_Wassenaar · Accepted solution]

You need to put the ceil inside the sum:

sum(ceil(pcs/[pcs per pallet]))