Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You need to put the ceil inside the sum:
sum(ceil(pcs/[pcs per pallet]))
See example
You need to put the ceil inside the sum:
sum(ceil(pcs/[pcs per pallet]))