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!

[alec1982]

Here is a sample.. Thank you!

[ashfaq_haseeb · Accepted solution]

Hi

may be like this.

Regards

ASHFAQ

[alec1982]

This worked for me. with no need for variables. Thank you!

[Anonymous]

This works for me:

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