- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2025 05:30 AM - edited 11-12-2025 05:32 AM
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
11-12-2025 06:05 AM
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
11-12-2025 06:05 AM
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.