10 Replies Latest reply: Jul 30, 2014 6:29 AM by Manish Kachhia RSS

    Sum of calculated field

      Dear all,


      I hope someone of you can help me again


      I have to following problem in a table diagram:
           - I want to sum all calculated fields




      Product 1     Offer 1     Balance1          Avg. Balance?

      Product 2     Offer 1     Balance 2         Avg. Balance?


      The Balance is a calculated field = Old Price - Offer Price
      Offer Price is a Input that I can call

      Old Price is again a calculated field out of different fields.


      I want to sum all the Balances and divide the sum by the number of products in the same offer. In short I need the avg. balance of all products


      I hope it is clear what I want to do.... THANKS FOR YOUR HELP !!!


      Cheers Martin