How to calculate guarantee incentive on Quarterly basis
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.