Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Cadet
8 years ago

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

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?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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()
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    Formula text field

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

    )


    New formula Numeric field

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