4 Replies Latest reply: Feb 18, 2016 3:53 AM by Chanty 4u RSS

    Issue while doing sum at record level

      Hi Team,


      I having issue while doing sum at record level. My expression returns sum of whole QUANTITY into average of whole RATE  by sum of whole VALUE


      Formula: sum(Qty)*Avg(Rate) / sum(Value)



      =(Sum({<Year={$(=max(Year))}>} Qty) * avg({<Year={$(=max(Year))} >}Rate))/

      (sum({<Year={$(=max(Year))} >} DISTINCT (Value))))


      Note: Using current year.


      Please check attached sheet for more details and with e.g.


      Quick help will be appreciated.