3 Replies Latest reply: May 22, 2018 7:55 AM by youssef belloum RSS

    Convert Nulls in pivot table to blanks

    Jason Zhu

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