Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Help with if/and/then statements — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with if/and/then statements

Received Response
25
Views
2
Comments
edited Jan 30, 2017 9:23PM in Reporting and Analytics (TBE) 2 comments

Summary

If x and y then a else b

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!