Convert Nulls in pivot table to blanks

[Anonymous]

Hi I want to use set analysis to change null values in my pivot table to blanks. I want to do this in the front end and not in the load editor script.

I tried detecting nulls and setting them equal 'blank' but it doesnt seem to be working. Nulls in my pivot are still being represented as a greyed out box with '-'in them. Any help would be greatly appreciated!

Attempted Code:

if(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])=0 OR

IsNull(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])),'',

Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty]))

[YoussefBelloum]

Hi

try this instead

if(len(trim(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])))=0,'',

Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty]))

[Anonymous]

Thanks for the quick response! When i try this it actually turns all the Null or 0 values to a greyed out '-' box. Which i assume represents Null.

[YoussefBelloum]

the expression above replace NULL and BLANK values with a blank.. so you should not see '-' anymore on the table..