Include null value in set analysis

[#1]

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

[tresesco]

try:

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

[kaushiknsolanki · Accepted solution]

Hi,

     The best way for this is you give a value to null values.

     Something like this.

     Load Field1, If(Isnull(Field2,'NULL',Field2)) as Field2 from xyz.

     Then you can just use the NULL in search to get the null data.

Regards,

Kaushik Solanki

[er_mohit]

try this

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

[#5]

why i never think of this? hee. thank you.