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

IF Formula Not Working

Accepted answer
29
Views
7
Comments
edited Apr 20, 2020 4:42PM in Reporting and Analytics (TBE) 7 comments

Summary

Expression "if (var1) var2 else var3" not working

Content

Hi there,

I'm trying to add an "IF Expression" into my report, but it's giving me an error.

My formula is If field is "eligible" then Yes, else Blank. (please see attachment)

IF([CAND|CAND-REQU_CAND|REQU-REQU_CAND|CUSTOM_1439] =="Eligible") "Y"

I took this format of the formula from the help recruit.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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