3 Replies Latest reply on Jul 12, 2018 9:52 PM by Zhouyi Zhang

    Percentages in this table that is made up of calculated fields

    Jenny McIntyre

      Hi All.......I seem to be unable to turn the data in the Destination Status tab into what percentage of loads were processed under 40 mins and over 40 mins.  These fields are made up to calculated fields.  I'd like to be able to filter the destinations and by a specific month.  I've copied from excel the percentages that show the desired results. You will see when I do a calculated field '% deliveries with 40 mins' it doesn't work.  Appreciate some help cheers!

      62%38%
      9%91%
      57%43%
      27%73%
      54%46%
      24%76%
      40%60%

       

      Above are the desired percentages