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

Need help creating a "Countif" formula

edited Dec 13, 2022 6:57AM in Taleo Enterprise

Content

I apologize if this has been asked and the solution is out here somewhere. I didn't see anything when I searched the Discussion Forum. 

I am trying to create a formula that will count the number of Educations a user has added in their Talent Profile based off whether they inputted a degree or not.  I can handle a straight count formula: =Count([Profile Education - Education Level (Code)]).  BUT one of the selection choices is "NONE" and I don't want this counted.  I tried: =Count([Profile Education - Education Level (Code)]<>"NONE"), but this didn't work and actually created a new problem by counting those with no Education listing as "1".  I tried a few other ways, all to no avail.  Anyone have any suggestions?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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