Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
frm where ur getting year filed?
chk dis
You explain what you are trying to do, but what is the question/issue?
chk dis
its wrkng fyn