Good day. Just want to know the default value if nothing has been selected from a filter widget. I'm trying this formula

CASE
WHEN AP_Dashboard_xlsx.Market = NULL
THEN (AP_Dashboard_xlsx.Headcount / 7305)*100
END

But it's showing no value


------------------------------
CAMILO CARLO MENDIOLA
------------------------------

#CognosAnalyticswithWatson

Hi Camilo,
It is likely that the value is not NULL, but instead is empty or just spaces.
When you look in the grid view, does it show NULL or an empty cell ?
If it shows NULL then the above should have worked, in that case maybe you can send me a sample xlsx file that has the problem.
Which version are you on?
// Henk

------------------------------
HENK CAZEMIER
------------------------------