Issue while doing sum at record level

[#1]

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

[Chanty4u]

frm where ur getting year filed?

[Chanty4u]

chk dis

[jonathandienst]

You explain what you are trying to do, but what is the question/issue?

[Chanty4u]

chk dis

its wrkng fyn