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

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

John Romno

  • 120 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 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.


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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")