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

  • 0
  • 1
  • Question
  • Updated 1 year 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 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

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

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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()
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Formula text field

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

)


New formula Numeric field

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

(Edited)