Need Help For Sum Function

[Anonymous]

Hi everyone,

When multiple selections are made on the data model,I just want to process the biggest one. The code structure looks like this:

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

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

For example, when I choose 2015-2016-2017-2018,  I want sum of data for 2018. This code is included all the years.

Please help me.

[sunny_talwar]

May be try this (Remove the equal sign before the dollar sign expansion for Year's modifier

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

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

[shiveshsingh]

Hi Sunny

I think '=' sign before $ is not the correct way while using set analysis?

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

[sunny_talwar]

I believe so... that is why I recommended to remove it.

[shiveshsingh]

Thanks

[sunny_talwar]

Hahahaha no problem

[Anonymous]

Thank you so much guys

İt works

[shiveshsingh]

Please close the thread