Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Bit stuck with this one, was trying to get the Max Wave for a particular leasing Company
I had this formula so far but doesn't seem to be working any ideas ?
=Max(<[Leasing Company]=$(vLeaseCo),Wave)
Thanks
Sarah
If Wave is string, then use MaxString()
=Max({$<[Leasing Company]={'$(vLeaseCo)'}>}Wave) --Removed comma before Wave
=Max({$<[Leasing Company]={'$(vLeaseCo)'}>},Wave)
Sorry just tried and it said error ') expected
If Wave is string, then use MaxString()
=Max({$<[Leasing Company]={'$(vLeaseCo)'}>}Wave) --Removed comma before Wave
if it is a string you will need the maxstring() function