Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Just remove a space in your BudgetDate field modifier (the one after the first single quote):
=Sum({< BudgetDate = { '$(=Max(BudgetDate))'}, BudgetLevel = {'3'} >} Available)
HI
Try like this
=Sum({<BudgetDate = { ' $(=Max(BudgetDate))'},BudgetLevel = {'3'}>}Available)
Regards,
R.Mayil Vahanan
That did not solve the issue. I've attached a small example -- Chart with the issue is the one on the left.
Just remove a space in your BudgetDate field modifier (the one after the first single quote):
=Sum({< BudgetDate = { '$(=Max(BudgetDate))'}, BudgetLevel = {'3'} >} Available)