Discussions

Expand all | Collapse all

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.