Discussions

Expand all | Collapse all

Summary Report

  • 1.  Summary Report

    Posted 03-04-2017 00:25
    I have a summary report with a column of late loads per carrier and another with total loads per carrier. I want a 3rd column in % of late loads, Late loads/total loads?


  • 2.  RE: Summary Report

    Posted 03-04-2017 01:32
    In the summary settings you can check a box to define a calculated column.

    Then just format it how you'd like, and insert the formula.



  • 3.  RE: Summary Report

    Posted 03-04-2017 03:00
    You may find that you need to create a formula field called Late Loads %. Have it calculate to 1 if late and zero if not late. Format it as a Percentage


    Then put that in your report and set the Summy to Summarize Averages.