Skip to main content
Question

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

  • November 7, 2017
  • 0 replies
  • 18 views
Forum|alt.badge.img+5
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?
      This topic has been closed for replies.

      You cannot makes words appear in a formula numeric field.
      • MCFNeil
      • Registered
      • November 7, 2017
      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
      • Registered
      • November 7, 2017

      Formula text field

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

      )


      New formula Numeric field

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

      Terms & ConditionsAccessibility statement