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.