10 Replies Latest reply on Jan 24, 2017 6:58 PM by Vishal D

    Want to calculate max(time_taken) for each unique field value

    Vishal D

      Want to calculate Gallons/ per minute.


      Total Gallons = Sum of all (Net Qty) by each Lane e.g 12494


      Total Minutes = Sum of max(time_taken) for each unique ticket number  e.g 1918


      Gallons per minute = Total Gallons/ Total Minutes e.g 6.51


      How do I calculate 'Total Minutes' logic?


      See attached spreadsheet for sample data.