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:

       

      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?