Discussions

Expand all | Collapse all

I am trying to end a Numeric Formual with a text statement, is this possible?

  • 1.  I am trying to end a Numeric Formual with a text statement, is this possible?

    Posted 05-07-2018 21:15
    What am I missing with this formula?
    If
    ([3PWMA]<>0,([On_Hand])/(([3PWMA]*4)/250),ToText("No Usage")


  • 2.  RE: I am trying to end a Numeric Formual with a text statement, is this possible?

    Silver
    Contributor
    Posted 05-07-2018 21:18

    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.




  • 3.  RE: I am trying to end a Numeric Formual with a text statement, is this possible?

    Posted 05-07-2018 21:20
    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")