SET ANALYSIS

[adiarnon]

HI,

i have a problem with set analysis-

this is my expression

SUM({<For_Year={$(<=Max([SO YEAR L]))}>}SO_LINE_SALES_VALUE_USD)

do you know why this expression is not working?

if im not putting the < its working...

tnx,

adi

[jonathandienst · Accepted solution]

That should be

SUM({<For_Year={"<=$(=Max([SO YEAR L]))"}>} SO_LINE_SALES_VALUE_USD)

[jagan]

Try like this

SUM({<For_Year={'<=$(=Max([SO YEAR L]))'}>}SO_LINE_SALES_VALUE_USD)

Regards,

Jagan.

[sunny_talwar]

This should also work:

Sum({<For_Year={$(='<=' & Max([SO YEAR L]))}>} SO_LINE_SALES_VALUE_USD)