Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
Hi
try this instead
if(len(trim(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])))=0,'',
Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty]))
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.
the expression above replace NULL and BLANK values with a blank.. so you should not see '-' anymore on the table..