I can create the template for calculate number for this report but I think in the finally we need to confirm number from operation team in require part
and TMS officer will send Trip KPI report at 5 AM everyday so I think it will be better if operation team can help to do this report.