function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Khan McSweenKhan 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 SuranjiSampath 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​

All Answers

Sampath SuranjiSampath 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 McSweenKhan McSween
Brilliant Sampath, worked straight away! thanks very much, Khan