Help with if/and/then statements
SummaryIf x and y then a else b
I am creating a new hire report that can identify when an exempt status for a position may need to be changed. My report has a field called "Exempt Status" and a field called "Pay rate".
I want the report to produce a result of "FALSE" if exempt status equals "exempt" and the pay rate field is less than 47476. Here's the expression I have so far:
if([CAND|CAND-REQU_CAND|REQU-REQU_CAND|CUSTOM_588]="Exempt" and [CAND|CAND-REQU_CAND|REQU_CAND-OFFER|payRate]<47874, "FALSE" "TRUE"
Taleo says this expression is not valid. Any ideas on what I'm doing wrong?