4 Replies Latest reply: Jul 18, 2013 9:21 PM by genieworks RSS

    Include null value in set analysis

      Hi,

       

      I've created a variable, vMyValue, which contain all the values that i need to compare in my analysis.

      My analysis would be something like this:

       

      Sum({<BUD_UNBUD={$(vBudgetConfig)}>}TotalBudget)

       

      My question is I want to compare if the BUD_UNBUD = 'Budgeted' and null, then it will proceed to sum. How should I include the "Null" value in my variable?

       

      Thanks.

      Eugene