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

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
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]"
Photo of Troy Tyler

Troy Tyler

  • 180 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
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],
Photo of Troy Tyler

Troy Tyler

  • 180 Points 100 badge 2x thumb
That did it! Thanks for the help.