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?
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)