Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
Khan McSween

# tiered formula to calculate client fees

Hi There, i am trying to work out how to produce a formula that will calculate the fee due based on the total fund value which can be populated in. The currency field which will be populated is called 'Total transfer value for Tiered Fee'.

when this field is populated with a value i need the formula to calculate the following:

3% of the first £500k
2% of the next £250k
1% thereafter. If the total after calculating this, exceeds £30,000, i need this to deliver £30k as the maximum.

Any help would be greatly appreciated!

thanks,

Khan

Best Answer chosen by Khan McSween
Sampath Suranji

Hi Khan,
Try below formula(currency type) by replacing 'Amount' field to perticular currency field in your object
`IF( Amount <500000,Amount*0.03,IF( AND(750000>Amount,Amount>500000),500000*0.03 + (Amount-500000)*0.02,IF(AND(Amount>750000, (500000*0.03+250000*0.02+ (Amount-750000)*0.01) <30000 ),500000*0.03+250000*0.02+ (Amount-750000)*0.01,30000)) )`

Best Regards
Sampath​

Sampath Suranji

Hi Khan,
Try below formula(currency type) by replacing 'Amount' field to perticular currency field in your object
`IF( Amount <500000,Amount*0.03,IF( AND(750000>Amount,Amount>500000),500000*0.03 + (Amount-500000)*0.02,IF(AND(Amount>750000, (500000*0.03+250000*0.02+ (Amount-750000)*0.01) <30000 ),500000*0.03+250000*0.02+ (Amount-750000)*0.01,30000)) )`

Best Regards
Sampath​
This was selected as the best answer
Khan McSween
Brilliant Sampath, worked straight away! thanks very much, Khan