Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Cadet
7 years ago

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

What am I missing with this formula?
If
([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago

    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.


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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")