MTD function in set analysis

[VVJ]

Hi,

I'm trying to calculate the sum of sales for a particular month (month start to max date). I'm using the following syntax but not able to get the desired output.

sum({<day={">=(=monthstart($("vmaxdate")))<=($("vmaxdate"))}>}sales)

vmaxdate is a variable where I have declared the max(day).

Please help to resolve this.

[Somasundaram]

Try this,

sum({<day={">=(=monthstart($("vmaxdate")))<=($("vmaxdate"))"}>}sales)

[hemachandran]

Hi,
Please try this
sum({<day={">=(=monthstart($("vmaxdate")))<=(=$("vmaxdate"))}>}sales)