3 Replies Latest reply: May 6, 2013 1:14 PM by Stefan Wühl RSS

    Set Analysis not working with a date Set Modifier

      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])