topic Convert Nulls in pivot table to blanks in App Development

Convert Nulls in pivot table to blanks

Anonymous — Tue, 22 May 2018 10:25:36 GMT

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]))

Re: Convert Nulls in pivot table to blanks

YoussefBelloum — Tue, 22 May 2018 10:28:01 GMT

try this instead

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

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

Re: Convert Nulls in pivot table to blanks

Anonymous — Tue, 22 May 2018 10:52:07 GMT

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.

Re: Convert Nulls in pivot table to blanks

YoussefBelloum — Tue, 22 May 2018 11:55:07 GMT

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