11 Replies Latest reply: Apr 28, 2014 12:16 PM by Manish Kachhia RSS

    set analysis (sum, avg, aggregation...)

      Hi all,

      I have a list of orders like the following :

      Order IDAmountCurrencyCurrency RateOrder Date


      I need to show, in a text box, the sum of all Amount in Euro where :

      sum of all Amount in Euro =sum of all orders and for every Order: sum(Amount) * the average of Currency Rate of the current Currency.

      that means, the average of Currency is calculated based on all other order having the same currency


      any idea ?