19 Replies Latest reply: Mar 18, 2014 10:31 AM by Manish Kachhia RSS

    SUM TOTAL and AVG

      Dear all,

       

      I need a solution for my problem. I want to use the totals of the tables below for further calculations.

      There must be a solution, but I couldn't find it. I tried AGGR, sum(total <field>), but without result.

      code-order.gif

      Order 960 has 5 codes of 30 and order 961 has 1 code of 30.

       

      I need the following figures:

      - Total Orderbedrag = 180

      - Avg Orderbedrag = 90

      - Avg Bonbedrag = 30

       

      Can you help me with this?

       

      Kind regards,

       

      Erwin