Hi
I'm trying to create the following formula for a sliding retention calculation based on an invoice amount as follows:-
1. If the current amount invoiced is less than $200,000 retention value is 10%
2. If the current amount invoiced is between $200,000 and $800,000 the retention value is...