https://netsuiteprofessionals.com logo
Title
p

Paul_s

03/02/2021, 10:24 AM
Trying to do a SS with a formula numeric multiplying one field by another, however one of the fields seems to have been setup as a text field even though it will only ever contain numbers, what are my options for using it in the formula?
n

Netsuite Tragic

03/02/2021, 10:26 AM
you can use it with TO_NUMBER({fieldname}) to convert it. (You could fix your problem long term by exporting that field data, change the field type and reimport.)
p

Paul_s

03/02/2021, 10:27 AM
Okay, that was embarrassing that I forgot that one. Thanks for the assist!