Formula text in saved search
hello, i am currently trying to figure out how to turn a text field into a numeric one using the to_num syntax so i can then use that number in a different formula. which would be record 2
example (record1) / (record2), record 2 could possibly be 1 or it could be up to 6 . how would i get this number value?
On the Saved Search, select a field type of Formula (Numeric) and enter the formula as:
TO_NUMBER({field_id})
And once you’ve tested that you can expand the formula as needed.
@ abbott, thank you for your response, unforutnely i am not able to get this to work, i get an invalid expression.
Change the field type to Formula (text) and in the formula field use this TO_NUMBER({field_id}).
Since the original field is of text type, NS giving invalid expression when used with Formula(Numeric).
Hope this works!
