edit bug in set expression

[pratap6699]

sum({<year={"(='>='&year) & ='<='&Max(year-2)"}>}spent)

i want to show greater than selected year and less than max(year-2) result...my condition is correct but i didn't get any result please help me

[Anonymous]

I made a few fixes, try it:

sum({<year={"$(= '>=' & year & '<=' & Max(year)-2)"}>} spent)

[pratap6699]

HAI THANKS FOR RESPONCE MR MICHEL BUT ITS NOT WORKING.... IT NOTHING SHOW IN CHART

[sunny_talwar]

I don't know if adding a max to first year will make a difference or not, but try this (further editing Michael Solomovich‌ suggestion)

sum({<year = {"$(= '>=' & Max(year) & '<=' & Max(year)-2)"}>} spent)

Best,

Sunny

[maxgro]

don't know if I understand

y= year

v=spent

>= selected year or <= selected year -2

sum({$ <y={">=$(=max(y))"}>+<y={"<=$(=max(y)-2)"}> } v)

>= selected year and <= selected year -2 (always 0)

sum({$ <y={">=$(=max(y))"}>*<y={"<=$(=max(y)-2)"}> } v)

between year-2 and year

sum({$ <y={">=$(=max(y)-2)<=$(=max(y))"}>} v)

[Anonymous]

Good point

Sales in >= 2015 and <=2013 can only return 0

[pratap6699]

see the result it is also no working