Discussions

Expand all | Collapse all

I'm looking for help with a ""Type Conversion

  • 1.  I'm looking for help with a ""Type Conversion

    Posted 11-06-2017 23:46
    My formula is If(
    [12 Month Sales]=0,"No Usage",
    ([On Hand])/([3PWMA]*4/250))

    The field type is Numeric, how do I get "No Usage" to display?


  • 2.  RE: I'm looking for help with a ""Type Conversion

    Posted 11-07-2017 00:53
    You cannot makes words appear in a formula numeric field.


  • 3.  RE: I'm looking for help with a ""Type Conversion

    Top
    Contributor
    Posted 11-07-2017 04:17
    I'd recommend changing the field type (if its a new field and not used in other calculations) 
    or
    create a new formula text field.

    You will want to convert the number to text with something like ToText() or ToFormattedText()


  • 4.  RE: I'm looking for help with a ""Type Conversion

    Silver
    Contributor
    Posted 11-07-2017 14:20

    Formula text field

    If(
    [12 Month Sales]=0,"No Usage",totext([new formula numeric field])

    )


    New formula Numeric field

    [On Hand]/([3PWMA]*4/250)