Discussions

View Only

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

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

Posted 01-22-2018 20:12
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]-[Start Time]))*[Field Rep - Hourly Rate]+[Field Rep - Travel Fee])>=[Field Rep - Minimum Rate],<>,"[Field Rep - Minimum Rate]"_

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

Posted 01-22-2018 20:19
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],

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

Posted 01-22-2018 20:30
That did it! Thanks for the help.