4 Replies Latest reply: May 26, 2011 8:53 AM by kkuntz567 RSS

    Changing null from '-' using text in chart

      I'm working on an ERP dashboard and need to change the value of text-in-chart for my gauge chart from '-' to 'No Selection' as the users find it confusing when no field is selected, I've tried to implement an = If statement  but can't seem to get it to work.

       

      This is the current expression:

       

      =If(IsNull(GetCurrentField([SH Group]), 'No Selection', Num($(Rule1Dial),'#,##0.00%')

       

      The default Null display is still '-' and my calculation no longer runs, however when the expression just reads

       

      =Num($(Rule1Dial),'#,##0.00%')

       

      I get the correct weighted percentage, but the Null value is still a hyphen. Would appreciate any help.