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]

       

      END

       

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

       

      Anyone know a work around for this?


      Thank you!

       

       

      Shelby