Forum Discussion

DangThai's avatar
DangThai
Qrew Trainee
7 years ago

How to calculate fee based on package size, incurred daily 60 days after [Date Received] to a max of 30 days

Here are the criteria: 3 different [Package Size]  each [Package Size] has a different fee fees are calculate after 60 days after [Date Received]. On the 61st day, the fee begins. fees are charg...
Formulas and functions
KevinSlider's avatar
KevinSlider
Qrew Trainee
7 years ago
Not sure exactly what you are looking for, but take a look at the formula  below. Let me know if that helps.

var number DaysOverDue = Min(90, ToDays(Today()-[Date Received])); //# of days late or 90, which ever is smaller

If(
([Package Size]="Light") and ($DaysOverDue>60),(($DaysOverDue-60)*.5), //50 cents every day after 60 days
([Package Size]="Regular") and ($DaysOverDue>60),(($DaysOverDue-60)*.75), //75 cents every day after 60 days
([Package Size]="Large") and ($DaysOverDue>60),(($DaysOverDue-60)*1), // 1 dollar every day after 60 days
0)