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.
@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
@OTrieger thank you for your help. You had it spot on