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
