In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Custom Formula Function

Dav
7 - Meteor

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])

2 REPLIES 2
OTrieger
14 - Magnetar

@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

Dav
7 - Meteor

@OTrieger thank you for your help. You had it spot on

Labels
Top Solution Authors