7 Replies Latest reply on Jun 6, 2013 8:49 AM by Laura Kazan

    Calculated field to return different number formats

    Laura Kazan

      I have found a variety of answers to this question but none fit my specific issues so here goes:


      I need to format a number in a calculated field. If one condition is true then it needs to allow for a decimal. If that condition is not true then I don't want the decimal. So it is something like this...


      if contains(color "red") then [value with no decimal]

      else [value with decimal]



      How do I format a number?


      I have seen a number of posts that wish for a format function. I add my vote...