* (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:
* 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.