Need Help For Sum Function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

When I make multiple selections on the data model, I want the biggest year's data to be processed. Code structure;

(((Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}> } In_Qty)) -

(Sum({$<Year={"=$(=(Max(Year)))"}, Month={"<=$(=(Max(Month)))"}>} Out_Qty))))

When I choose all years sum data for all years but i want the only biggest year in my selection.

Please help me.

Re: Need Help For Sum Function

shiveshsingh — Thu, 22 Feb 2018 17:27:21 GMT

Try removing '=' sign before $ in Year set analysis.

{$<Year={"$(=(Max(Year)))"}