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

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

Calculating Percent Difference between two columns

edited Dec 13, 2022 7:03AM in Taleo Enterprise 1 comment

Summary

Calculating Percent Difference between two columns

Content

Hello - Does anyone know the best way to calculate the percent difference between two columns? We are trying to calculate the percent delta between our proposed budget (annual) for a position against the actual budget (annual) that was presented to the candidate. I'm having some difficulty as the two fields I am comparing are not like fields. Rather, one field is a UDF and the other field is a custom formula.

Example:

Annual Base Salary (Budgeted): "Requisition UDFs"."Requisition UDF Value 03"

Annual Base Salary (Actual): Case When "Application Job Offer"."Job Offer - Pay Basis" ='Weekly' Then (52*"Application Job Offer"."Job Offer - Salary (Pay Basis)") Else (2080*"Application Job Offer"."Job Offer - Salary (Pay Basis)") End

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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