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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    If or Replace function Help

    edited Apr 26, 2016 11:16PM in Taleo Business Edition (TBE) 1 comment

    Summary

    Trying to figure out the script to change wording in a column. This is what I used in BO Reporting but does not work in OBI. Any suggestions?

    Content

    =If (C)]="INDIVIDUAL_CONTRIBUTOR") Then "Staff" ElseIf ([Employee Job Role Job Level (Code)]="TEAM_LEADER") Then "Lead" ElseIf ([Employee Job Role Job Level (Code)]="MANAGER_WITH_DIRECT_REPORTS") Then "Supervisor" ElseIf ([Employee Job Role Job Level (Code)]="MANAGER") Then "Manager" ElseIf ([Employee Job Role Job Level (Code)]="DIRECTOR") Then "Director" ElseIf ([Employee Job Role Job Level (Code)]="SENIOR_EXECUTIVE") Then "VP" ElseIf ([Employee Job Role Job Level (Code)]= "EXECUTIVE") Then "Executive" Else "Unassigned"

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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