Monday, November 11, 2013

Target Calculation using Target Module

Target Calculation

1. No need to create a payhead unless incentive is to be paid in salary.
2. Two keywords are used Value and Tot_value; value refers to the target achieved and Tot_value refers to the group target set.

The target module works for group incentive calculation. For individual employee target calculation you can do it by creation of payheads viz. Target Allocated, Target Achieved, Target Incentive.

Sample of formulas used in Target module are mentioned here under:

Example 1:
Case When "Value">=("Tot_Value"*75)/100 Then ("Tot_Value"*0.2)/100 When "Value">=("Tot_Value"*81)/100 Then ("Tot_Value"*0.3)/100 When "Value">=("Tot_Value"*91)/100 Then ("Tot_Value"*0.4)/100 When "Value">=("Tot_Value"*101)/100 Then ("Tot_Value"*0.5)/100 When "Value">=("Tot_Value"*111)/100 Then ("Tot_Value"*0.6)/100 Else 0 End

Example 2:
Case When "Value">=("Tot_Value"*75)/100 Then ("Tot_Value"*0.05)/100
When "Value">=("Tot_Value"*80.01)/100 Then ("Tot_Value"*0.1)/100
When "Value">=("Tot_Value"*90.01)/100 Then ("Tot_Value"*0.15)/100
When "Value">=("Tot_Value"*100.01)/100 Then ("Tot_Value"*0.2)/100

When "Value">=("Tot_Value"*110.01)/100 Then ("Tot_Value"*0.3)/100 Else 0 End

Example 3:
Case when "Value" between ("Tot_Value"*60)/100 and ("Tot_Value"*70.99)/100 then ("Tot_Value"*0.20)/100 When "Value" between ("Tot_Value"*71)/100 and ("Tot_Value"*80.99)/100 then ("Tot_Value"*0.25)/100 When "Value" between ("Tot_Value"*81)/100 and ("Tot_Value"*90.99)/100 then ("Tot_Value"*0.30)/100 When "Value" between ("Tot_Value"*91)/100 and ("Tot_Value"*100.99)/100 then ("Tot_Value"*0.35)/100 When "Value" between ("Tot_Value"*101)/100 and ("Tot_Value"*114.99)/100 then ("Tot_Value"*0.40)/100 When "Value">=("Tot_Value"*115)/100 then ("Tot_Value"*0.40)/100 + ("Value" - (("Tot_Value"*114.99)/100))/100 else 0 end

Example 4:
Case when "Value" between ("Tot_Value"*60)/100 and ("Tot_Value"*114.99)/100 then ("Tot_Value"*0.10)/100 Else 0 End

Blog by BBSPL