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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
  • (Edited)
What am I missing with this formula?
([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")
Photo of John Romno

John Romno

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chris


  • 4,430 Points 4k badge 2x thumb

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.

[3PWMA]<>0, [On_Hand]/[3PWMA] * 4 / 250, 0.1),ToText("No Usage")