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?
Forum Discussion
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()
or
create a new formula text field.
You will want to convert the number to text with something like ToText() or ToFormattedText()