Set analysis error

[alec1982]

Hi guys,

Anybody could help me on this.

What could be wrong with this expression

Sum({$<Invoice_MonthYear={$(MaxYearMonth)}>}INVOICE_AMOUNT)

Knowing that $(MaxYearMonth)=201404.

If I replace the variable above with its value like:

Sum({$<Invoice_MonthYear={'201404'}>}INVOICE_AMOUNT) it returns the right value but when i replace it with the variable above it returns error!

[#2]

try:

Sum({$<Invoice_MonthYear={$(=MaxYearMonth)}>}INVOICE_AMOUNT)

[ashfaq_haseeb]

try below

Sum({$<Invoice_MonthYear={$(=MaxYearMonth)}>}INVOICE_AMOUNT)

updated

Sum({$<Invoice_MonthYear={$(=Max(YearMonth))}>}INVOICE_AMOUNT)

Regards

ASHFAQ

[alec1982]

Still the same error

[#5]

share application

[Anonymous]

Maybe

Sum({$<Invoice_MonthYear={'$(MaxYearMonth)'}>}INVOICE_AMOUNT)

[ashfaq_haseeb]

like this

Sum({$<Invoice_MonthYear={$(=Max(Invoice_MonthYear))}>}INVOICE_AMOUNT)

Regards

ASHFAQ

[alec1982]

I am still getting the error..

Unfortunately I cannot share the app. I have used the same expression somewhere else and it worked..Not sure if the expression is not recognizing the value of the variable..

Let me know your thoughts.. and thank you for all your help!

[#9]

Please attach example. It is difficult to guess without a view...

[PradeepReddy]

try this....

Sum({$<Invoice_MonthYear={"$(=Max(YearMonth))"}>}INVOICE_AMOUNT)

If still not working.. pls share the application....