2 Replies Latest reply: Feb 21, 2013 9:58 AM by Gysbert Wassenaar RSS

    Aggregate ceiled rows

      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:




      * 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?