Calculating Percent Difference between two columns
Summary
Calculating Percent Difference between two columnsContent
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
Tagged:
0