Skip to main content
Question

Type Conversion

  • February 8, 2022
  • 0 replies
  • 80 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • February 8, 2022
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
------------------------------
Terms & ConditionsAccessibility statement