Forum Discussion
ChayceDuncan2
6 years agoQrew Cadet
Do you have different values for deductions based on it being hours versus days?
Either way - you're going to want to user an if() statement versus a Case() and check to see if the duration is more than a day and then do your multiplier. Something like this
If( ToDays([Time Overdue]) >= 1,
//Do this if the time overdue is a day or more
ToDays([Time Overdue]) * [Deduction For Days],
//Otherwise do this
ToHours([Time Overdue])*[Deduction For Hours] )
Either way - you're going to want to user an if() statement versus a Case() and check to see if the duration is more than a day and then do your multiplier. Something like this
If( ToDays([Time Overdue]) >= 1,
//Do this if the time overdue is a day or more
ToDays([Time Overdue]) * [Deduction For Days],
//Otherwise do this
ToHours([Time Overdue])*[Deduction For Hours] )