Skip to main content
Question

I am trying to end a Numeric Formual with a text statement, is this possible?

Forum|alt.badge.img+5
What am I missing with this formula?
If
([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")
      This topic has been closed for replies.

      No, a numeric formula field expects a numeric result. you could make your formula text, then you can do what you wish for visual purposes. Have a companion numeric formula field for working any arithmetic you may need to perform.


      A field of type formula numeric must calculate to be a numeric or null value.
      you alternative would be to make it a formula text field, but then you would not be able to do any arithmetic operations on it.

      You would need to convert the numeric to text.

      IF(Round(
      [3PWMA]<>0, [On_Hand]/[3PWMA] * 4 / 250, 0.1),ToText("No Usage")
      Terms & ConditionsAccessibility statement