Forum Discussion

TroyTyler's avatar
TroyTyler
Qrew Trainee
8 years ago

Trying to get this formula to work and I'm sure it is an easy fix. Help!

Boolean formula help. Here is the formula, I want it to return the result so long as it is greater than the [field rep-minimum fee], otherwise return the minimum fee. (ToNumber(ToHours([Stop Time]-...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Try this

Max(
ToHours([Stop Time]-[Start Time])*[Field Rep - Hourly Rate]+[Field Rep - Travel Fee],
[Field Rep - Minimum Rate])

That says to take the Max (ie the higher of)

ToHours([Stop Time]-[Start Time])*[Field Rep - Hourly Rate]+[Field Rep - Travel Fee]

 and 

[Rep - Travel Fee],