Replace NULL with NA



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.

Rakesh paul


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


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.