Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Trainee
3 years ago

Type Conversion

Help! I have a formula number field that I went to use display Text and a Number. The formula I'm trying to make work is.
If([3PWMA]=0,ToText("No Usage"),
(([Availabile]/[3PWMA])*20))

Is this formula doable?

------------------------------
John Romano
------------------------------
Formulas and functions
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    3 years ago
    You would need to do this in a Formula Text field as you can't display text in a Formula Number field.

    Just do the opposite of what you have here in a Formula Text:

    If(totext([3PWMA])="0", "No Usage",
    totext((([Availabile]/[3PWMA])*20)))

    I think that's correct, you'll have to try it.

    ------------------------------
    Jeff Peterson
    ------------------------------