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

    Sum of calculated field

    Martin Wosnitza

      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

       

      Example:

       

      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