Forum Discussion

JohnRomano's avatar
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"),

Is this formula doable?

John Romano

1 Reply

  • 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",

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

    Jeff Peterson