Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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)

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

4 Replies
Chanty4u
MVP
MVP

frm where ur getting year filed?

Chanty4u
MVP
MVP

chk dis

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Chanty4u
MVP
MVP

chk dis

its wrkng fyn

barchart.png