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 for...
Forum Discussion
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
------------------------------
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
------------------------------