Skip to main content
Question

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

  • January 23, 2018
  • 0 replies
  • 25 views
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]"_
    This topic has been closed for replies.

    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],
    • TroyTyler
    • Author
    • Registered
    • January 23, 2018
    That did it! Thanks for the help.
    Terms & ConditionsAccessibility statement