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?

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

Okay, that was embarrassing that I forgot that one. Thanks for the assist!