Unable to get values using Month

[#1]

hi,

     i m using Below expression:

    =Sum({$<Date = {"<=$(=MonthEnd(AddMonths(Max(Date),-1)))"}>}Amount)

It is Working fine .when i select on Date field it is fine .

Date field contains 21/1/2013 format

If i use Month(Date) and i select on particular month  it is giving output as 0.

Pls suggest me.

Thanks in Advance

Regards,

Divya

[giakoum]

this might help

[anbu1984]

What is the result of expr - MonthEnd(AddMonths(Max(Date),-1)) ? Is this result in date format?

Can you add sample qvw

[#4]

Hi,

PFA,

Thanks in Advance

[maxgro · Accepted solution]

=Sum({$<M=,Month={"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)