Month

[NavinReddy]

Dear All,

Please find the image

In this i want to fetch only 2014 ,Feb Data as Current month

for that month i should took only FEB,

Please create a variable that shows only Feb

  =Sum({1<Month={"<=$(=Max(Month))"},Year={'2014'}>}PAY_AMT)

This expression Im getting Both the Months Data How can i Fetch only FEB

Please Help Some one

Thanks In Advance

Niru

[maxgro]

=Sum({1<Month={FEB},Year={'2014'}>}PAY_AMT)

[Gysbert_Wassenaar]

Change Month={"<=$(=Max(Month))"} into Month={"$(=Max(Month))"}. The <= means smaller or equal. You want an exact match so don't use the <= comparison operator.

[swuehl]

Just change the smaller equal to an equal comparison or

=Sum({1<Month={'$(=Max(Month))'},Year={'2014'}>} PAY_AMT)

[NavinReddy]

No it will change month automatically

there i need to use variable only