Expression Error

[rxp03570]

Hi,

I'm trying to use a variable in an expression, but this doesn't seems to work. Here is my expression

Sum({<ATTRIBUTE2={'$(vPreviousMonth)'}>}Sales_Count) and

vPreviousMonth = Date(AddMonths(Max(Date#(ATTRIBUTE2, 'MMM-YYYY')),-1),'MMM-YYYY')

Any help here guys.

Thanks,

Rahul

[dplr-rn]

try

Sum({<ATTRIBUTE2={'$(=vPreviousMonth)'}>}Sales_Count)

[rxp03570]

Doesn't help Dilip

[dplr-rn]

Odd i tested that on my test app. try this just in case

{"=$(=vPreviousMonth)"}

if it doesnt give more details on format of the column , dimensions used etc.

[rxp03570]

This is the data type for this field, and the variable I defined is the same as above.

[jomar_ebonite]

I think the error is coming from the variable expression.

Try below.

vPreviousMonth

Num(Month(Date#(ATTRIBUTE2, 'MMM-YYYY')))-1 & Year(Date#(ATTRIBUTE2, 'MMM-YYYY'))