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.