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
13 - Pulsar

@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