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

    Issue while doing sum at record level

    Uday XYZ

      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)

       

      Expression:

      =(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.

       

      Thanks,

      Yudi