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

How to calculate guarantee incentive on Quarterly basis

edited Feb 8, 2024 9:38AM in Incentive Compensation 1 comment

Summary:

Hello Team,

We have requirement to Calculate prorated based Guarantee incentive.

If guarantee start date is between interval start date and interval end date then we need days differences between guarantee start date and interval end date.

We have created 3 columns in participant snapshot as Guarantee Start Date , Guarantee End Date and Guarantee Incentive.

Example: If the Interval start Date is 01/01/23 and End Date is 04/01/2023,

Guarantee Start date is 01/01/23 to Guarantee End Date is 05/30/23 . Total guarantee incentive days is 150.

Guarantee Incentive : 50000

That means in first quarter Guarantee incentive days is 91 and in second quarter Guarantee Incentive Days is 59. How can we get day difference calculation using performance measure.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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