5 Replies Latest reply: Aug 17, 2016 8:01 AM by Yadhunandhanan J RSS

    How to replace hyphen or ' - ' with 'No Data' in a Pivot Table?

    John Blomqvist

      Hi all,

       

      I have the following example:

       

       

      How do I replace the Dashes with 'No Data' instead?

       

      I tried this as a Measure but it does not work: If(Num(Sum(LineSalesAmount), '$##,###.00')=Null(), 'No Data', Num(Sum(LineSalesAmount), '$##,###.00'))