IF ELSEIF Invalid Type in Operator ==

jlrouquette

I'm getting the "invalid type in operator" error for this formula. I'm not sure what isn't correct about the way it's written.  MaxProbability is being generated by a formula to pulls the max value across the five respective columns for a single row.  In a new column, I would like to generate the output from the formula below.        

IF [MaxProbability] = [FinalScore_E] THEN 'E'
ELSEIF [MaxProbability] = [FinalScore_D] THEN 'D'
ELSEIF [MaxProbability] = [FinalScore_C] THEN 'C'
ELSEIF [MaxProbability] = [FinalScore_B] THEN 'B'
ELSEIF [MaxProbability] = [FinalScore_A] THEN 'A'
ELSE 'ERROR'
ENDIF 

unknown

Nothing wrong with formula; one of those fields either the max prob or the finalscore fields is a string. You are having a data type mismatch where you are setting equals from an integer/double to a string. ToString() or ToNumber() the appropriate field and you will get the result you are after.