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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of John Romno

John Romno

  • 120 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
You cannot makes words appear in a formula numeric field.
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I'd recommend changing the field type (if its a new field and not used in other calculations) 
create a new formula text field.

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


  • 4,430 Points 4k badge 2x thumb

Formula text field

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


New formula Numeric field

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