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

    Creating a "Final Approver" variable when number of approver on each requisition could be different

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

    Content

    Hello,

    I need to create a variable that will show me the name of the final approver  on requisitions, but the number of approvers for each requisition could be  different.

    I have attached a variable that had been suggested to me for this, but of the  110 requisitions in my report, only 1 has a name listed, 8 have "None" listed,  and the rest are all blank.  Does anyone have any ideas how I can report on who  the final approver of a requisition was when the number of approvers is not  consistent?

    Thanks

    Amy

    =If(IsNull([Req. Approver 3 Name (All  Agg.)]);If(IsNull([Req. Approver 2 Name (All Agg.)]);If(IsNull([Req. Approver 1  Name (All Agg.)]); If(IsNull([Req. Approver 4 Name (All Agg.)]); If(IsNull([Req.  Approver 5 Name (All Agg.)]); "None";[Req. Approver 1 Name (All Agg.)]); [Req.  Approver 2 Name (All Agg.)]);[Req. Approver 3 Name (All Agg.)]);[Req. Approver 4  Name (All Agg.)]); [Req. Approver 5 Name (All Agg.)])

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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