3 Replies Latest reply on Dec 21, 2016 8:21 AM by Shelby Lovejoy

    How to display N/A instead of an average for one category

    Shelby Lovejoy

      Looking for some help.


      I'm trying to display N/A for one of my categories. For the rest I want it to display the average amount.

      I tried doing a calculated field.

      I've attached a before and after/goal picture of what I mean. 


      IF [LienType]  = "Medicare" THEN [Initial Lien] = "N/A"

      ELSE [Initial Lien]




      But this give me the error: cannot compare integers with string values.


      Anyone know a work around for this?

      Thank you!