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")
Forum Discussion
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")
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")
