SQL Package Error When Adding Expression to Performance Measure Formula Incentive Compensation
Summary:
We need to calculate the commission rate for employees within an Annual Incentive Plan. On the performance measure we are adding a formula with the below logic:
Budget Achievement (Transaction Credit Amount) / Actual Budget (Data within UDT getting pulled into UDQ) = Performance Measure Achievement %
Performance Measure Achievement % will indicate, using the rate table, the employee's Earning Rate. The earning rate will be multiplied by the target incentive identified on the plan component level.
When we enter the expression into the performance measure formula, we get an error.
Can anyone provide guidance on next steps?
Content (please ensure you mask any confidential information):
Tagged:
0