Set Analysis not working with a date Set Modifier

[#1]

Want to limit budget information to the most recent selected date and third level of the budget.

Expression is in a chart.  When the BudgetDate set modifier is added to the expression, the chart says 'No Data to Display'.

The expression works without the BudgetDate set modifier.  Displaying Max(BudgetDate) in a text object shows the expected date.  The syntax seems correct.  I'm stumped.  Hints or suggestions are most appreciated.

SUM( {$ <    BudgetDate = { $ ( #=Max(BudgetDate) ) },
                   BudgetLevel = {'3'}
        > } [Available])

[MayilVahanan]

HI

Try like this

=Sum({<BudgetDate = { ' $(=Max(BudgetDate))'},BudgetLevel = {'3'}>}Available)

Regards,

R.Mayil Vahanan

[#3]

That  did not solve the issue.  I've attached a small example -- Chart with the issue is the one on the left.

[swuehl · Accepted solution]

Just remove a space in your BudgetDate field modifier (the one after the first single quote):

=Sum({< BudgetDate = { '$(=Max(BudgetDate))'}, BudgetLevel = {'3'} >} Available)