Community powered support for

Quick Base
What am I missing with this formula?

If

([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")

If

([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")

- 120 Points

Posted 9 months ago

Chris, Champion

- 4,390 Points

No, a numeric formula fieldÂ expects a numeric result. you could make your formula text, then you can do what you wish for visual purposes. Have a companion numeric formula field for working any arithmetic you may need to perform.

QuickBaseCoach App Dev./Training, Champion

- 57,802 Points

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