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]

      end

       

      How do I format a number?

       

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