3 Replies Latest reply on Jul 29, 2015 1:16 PM by Ben Page

    Need to show text when a calculated field answer is null

    Lynne Sciandro

      snag it.png
      I have a calculated field that determines a companies "Participation Rate" if the company does not send us information we cannot calculate this. Rather than having a blank or 0, management would like it to say "No Data"

      The calculation works: ifnull(str([Participation Rate]),"No Data"), however, when I use it in the worksheet, I cannot get text, I can only get color shapes.  Does anyone have a solution?

      Thank you.

      Lynne