Max of three expressions

[bradcusick]

Hello,

I am working on an expression for Fire Department response:

I have three expressions in a table.  2 find the minimum response time of a type of vehicle and 1 finds the response time of the 4th arriving specific typo of vehicle.  These expressions work great.

What I need to do is build an expression that finds finds the Max of these three values.  In the above example it would be 0:05:24.

I have tried versions of the below, but it does not work...

=Max({<Supp4={'>0'},BCResMin={'>0'},AmbResMin={'>0'}>} ([Travel Time]))

I have also tried several versions of the following without success (these are the expressions behind the values in the three columns):

=RangeMax

(Min({<[Unit Type]={'Ambulance'},[Response (Excel)]={'>0'}>} (Travel Time),

(Sum({<[Scene Arrival Order (Pump Heavy Apparatus)]={'4'}>} ([Travel Time])),

(Min({<[Unit Type]={'BC'},[Response (Excel)]={'>0'}>} ([Travel Time]) ([Travel Time])

Any ideas?

[sunny_talwar]

This isn't working?

=RangeMax(

Min({<[Unit Type] = {'Ambulance'}, [Response (Excel)] = {'>0'}>} Travel Time),

Sum({<[Scene Arrival Order (Pump Heavy Apparatus)] = {'4'}>} [Travel Time]),

Min({<[Unit Type] = {'BC'}, [Response (Excel)] = {'>0'}>} [Travel Time])

)

[bradcusick]

Looks like I had an extra parentheses.  It's working now!

Thanks