Set Analysis Issue

[rahulsingh12]

Hi,

I have written the following code which works fine

sum({<DateNew={"=$(=vL3MMax)"}>}[Volume(HL)]) gives 123

But as soon as I want the sum for the datenew greater than vL3MMax then It gives 0.

vL3MMax=AddYears(MAX(DateNew),-1) gives 0

sum({<DateNew={">=$(=vL3MMax)"}>}[Volume(HL)])

what is that I am doing wrong.

Regards

Rahul

[Anil_Babu_Samineni]

May be this?

sum({<DateNew={">=$(=$(vL3MMax))"}>}[Volume(HL)])

[sunny_talwar]

The variable definition stayed the same between the 2 tests? the only thing that changed was the addition of >=? or did you change the variable definition also?

[rahulsingh12]

The variable definition remained the same Sunny.

Regards,

Rahul

[tresesco]

Could you share a representative sample qvw to investigate?