RE: 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?

dctd22 Rookie Asked on December 2, 2019 in Saved Searches.
Add Comment
1 Answers

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.

Intermediate Answered on December 2, 2019.

@ abbott, thank you for your response, unforutnely i am not able to get this to work, i get an invalid expression.

on December 3, 2019.

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!

on December 5, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.