Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-22 07:15 PM
what does it mean to compare a text with a number?
------------------------------
Sam Lima
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-22 09:34 PM
Hi @SamLima
When you use a decision stage, its compare the data and the data type.
In this case, if you want to compare text against a number, you always return a False Flag. Even if you put "5" = 5 you get a False Flag.
In this cases, if you want to make a good comparation, you must to use "ToNumber()" function. (And also combine this with "IsNumber()" function to check first if the string can be converted to number)
Hope this helps you!
See you in the community, bye 🙂
------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------
When you use a decision stage, its compare the data and the data type.
In this case, if you want to compare text against a number, you always return a False Flag. Even if you put "5" = 5 you get a False Flag.
In this cases, if you want to make a good comparation, you must to use "ToNumber()" function. (And also combine this with "IsNumber()" function to check first if the string can be converted to number)
Hope this helps you!
See you in the community, bye 🙂
------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-22 07:42 PM
Could you please help
------------------------------
Sam Lima
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-04-22 09:34 PM
Hi @SamLima
When you use a decision stage, its compare the data and the data type.
In this case, if you want to compare text against a number, you always return a False Flag. Even if you put "5" = 5 you get a False Flag.
In this cases, if you want to make a good comparation, you must to use "ToNumber()" function. (And also combine this with "IsNumber()" function to check first if the string can be converted to number)
Hope this helps you!
See you in the community, bye 🙂
------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------
When you use a decision stage, its compare the data and the data type.
In this case, if you want to compare text against a number, you always return a False Flag. Even if you put "5" = 5 you get a False Flag.
In this cases, if you want to make a good comparation, you must to use "ToNumber()" function. (And also combine this with "IsNumber()" function to check first if the string can be converted to number)
Hope this helps you!
See you in the community, bye 🙂
------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------