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 

[Inactive User · Accepted solution]

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.

[jlrouquette]

Awesome, thank you!

[JP23]

Thanks, this was super helpful!

[mgarcia174]

I was having a similar issue and this resolved it. Thanks, super helpful!

[tk123]

So what is the actual solution?

[Marko1986]

I tried your solution but it is not correct for my problem. All fields that I want to use are double, and still I have invalid type in operator error.

Problem in attachment

[BenMoss]

In your formula you need to take the = "0" out of qoutes, it should be = 0

Ben

[Shelaj]

Really Helpfull...........Thanks

[namans0297]

Thanks, Super helpful :)