Re: Formula to Calculate Amount Due

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.