- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago - last edited 5 hours ago
Hello,
On my form I have a currency field ('Amount') and in the Flow Designer I added an IF branch. I have different scenarios such as:
IF
(Amount) GREATER THAN or is 100000
(Amount) LESS THAN 150000
{do stuff}
ELSE IF
(Amount) GREATER THAN 500000
{do stuff}
The problem is that when logging the value from the currency field it is retrieved as e.g. 140.000,00. So my IF statement is returning FALSE even if it should retry TRUE. I've tried also with num(100000) but i get the same issue.
I can't script anything in the IF action so really not sure where to go from here.
Any ideas?
Thank you,
Elena
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
Solution found! Found out that the IF statement converts the currency field into a string, so with fx->string->convert string to number solved the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
Solution found! Found out that the IF statement converts the currency field into a string, so with fx->string->convert string to number solved the issue.
