Replace NULL with NA

frontend

#1

Hi All,

Working on OLAP table, where I have list of dynamic dimension and multiple measure. There are some NULL value in the dimensions. Which eventually want to replace with NA.

Any leads will be highly appreciable.

Regards,
Rakesh paul


#3

We handle it with a Case When statement in either a variable or in a component filter.

CASE WHEN ISNULL(“Table”.“Field”) = 1 THEN ‘N/A’ ELSE “Table”.“Field” END


#4

Sorry, I need to correct my statement above. We used the CASE WHEN statement either as a variable and just call the variable, or we do it directly in the code editor as a dimension. We’ve used a component filter to exclude NULL results from a list but not change them to something else.