SOLVED
Custom Formula Function
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Dav
7 - Meteor
‎02-13-2025
03:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All
I have a formula which I remember using without issue. Trying to run my automation again and now the system does not like the formula
Can you help,
IF (IsNull([GTH Charge rate]) OR IsNull([GTH_Charge_Rate CoE])) THEN
"Missing data"
ELSEIF ([GTH Charge rate] = [GTH_Charge_Rate CoE]) THEN
"Correct" ELSE
"Validate"
ENDIF
It doesn't like the = ([GTH Charge rate] = [GTH_Charge_Rate CoE])
Solved! Go to Solution.
Labels:
- Labels:
- Alteryx Practice
2 REPLIES 2
OTrieger
13 - Pulsar
‎02-13-2025
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dav
Check if the data type of any of the fields have changed and now you have let say Double compared to String etc. That will be the first thing that I would check, as data type might be influenced from the reported data
‎02-14-2025
02:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@OTrieger thank you for your help. You had it spot on
