topic Re: Issue while doing sum at record level in App Development

Issue while doing sum at record level

Wed, 17 Feb 2016 15:55:04 GMT

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 — Thu, 18 Feb 2016 08:44:00 GMT

frm where ur getting year filed?

Chanty4u — Thu, 18 Feb 2016 08:46:57 GMT

chk dis

jonathandienst — Thu, 18 Feb 2016 08:47:03 GMT

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

Chanty4u — Thu, 18 Feb 2016 08:53:52 GMT

chk dis

its wrkng fyn