Using Conditional Formula to capture "Greater Than" value

[nancyyu]

I am attempting to use the Formula tool to write a formula that retrieves result A if A is larger than B, but retrieve B if otherwise for many rows of data. I have written the formula below, but am seeing an "Invalid type in operator >" message. Is this not the best way to do this?

IF [Total Hours Worked (Rehired or Terminated)]>[Total Project Hours per Employee] THEN [Total Hours Worked (Rehired or Terminated)] ELSE [Total Project Hours per Employee] ENDIF

[Thableaus · Accepted solution]

Hi @nancyyu 

Is your field a Numeric Type or a Date Type?

It's possible that compared fields are not the same type.

Cheers,

[nancyyu]

Duh! Yes, one of the fields was a string type. I corrected it and the formula now works. Thank you!!!