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
------------------------------
Original Message:
Sent: Thu February 20, 2020 02:58 AM
From: CAMILO CARLO MENDIOLA
Subject: Default value for filter widget in Dashboard
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