Hi Team,
I have a requirement to calculate incentives for CRM users in the Incentive entity, and I would like to know whether this can be achieved using Formula only, or if it requires a Workflow.
Requirement
Incentive should be calculated only if the Number of Conversions with Payments for the current month is greater than or equal to 10.
Each Migration Process has a Case Value, which includes 10% GST.
Before calculating the incentive, I need to exclude GST by reducing the Case Value by 10%:
GST Excluded Amount = Converted Amount × 0.90
The incentive percentage depends on the Payment Type of each Migration Process:
First Installment / Second Installment / Third Installment
Incentive = GST Excluded Amount × 5%
Full Payment / Final Payment Paid
Incentive = GST Excluded Amount × 10%
The final Incentive Amount should be the sum of all eligible Migration Processes.
Example
Suppose there are 10 conversions with payments:
9 Migration Processes have First Installment Paid
1 Migration Process has Full Payment
The incentive should be calculated as:
(9 Installment Cases × GST Excluded Amount × 5%)
+
(1 Full Payment Case × GST Excluded Amount × 10%)
and the total of both calculations should be stored in the Incentive Amount field.
I have a requirement to calculate incentives for CRM users in the Incentive entity, and I would like to know whether this can be achieved using Formula only, or if it requires a Workflow.
Requirement
Incentive should be calculated only if the Number of Conversions with Payments for the current month is greater than or equal to 10.
Each Migration Process has a Case Value, which includes 10% GST.
Before calculating the incentive, I need to exclude GST by reducing the Case Value by 10%:
GST Excluded Amount = Converted Amount × 0.90
The incentive percentage depends on the Payment Type of each Migration Process:
First Installment / Second Installment / Third Installment
Incentive = GST Excluded Amount × 5%
Full Payment / Final Payment Paid
Incentive = GST Excluded Amount × 10%
The final Incentive Amount should be the sum of all eligible Migration Processes.
Example
Suppose there are 10 conversions with payments:
9 Migration Processes have First Installment Paid
1 Migration Process has Full Payment
The incentive should be calculated as:
(9 Installment Cases × GST Excluded Amount × 5%)
+
(1 Full Payment Case × GST Excluded Amount × 10%)
and the total of both calculations should be stored in the Incentive Amount field.