Formula to Calculate Amount Due
I have a table called Task with a one to many relationship to another table called Criteria. On the Criteria table I have the following fields: [Task - Date Identified] (lookup Date/Time) - lo...
Forum Discussion
Ok that works when my deduction is set up for hours but when I am doing 3 days my deduction is based on days as well. i.e deduction period is 7 days my deduction is $5,000 per day (for anything over 7 days). So I would need the formula to say to take that into consideration.
I am wondering if I could use a case function that says something like:
Case([Deduction Period] contains "Hours", ToHours([Time Overdue]*[Deduction]),ToDays([Time Overdue]*[Deduction]))
But I am not sure how to make the first part of the formula work.
I am wondering if I could use a case function that says something like:
Case([Deduction Period] contains "Hours", ToHours([Time Overdue]*[Deduction]),ToDays([Time Overdue]*[Deduction]))
But I am not sure how to make the first part of the formula work.