5 Replies Latest reply: Feb 5, 2013 11:56 AM by Jim Feng RSS

    Help Please~total cubic feet for all the boxes in a period

      CompletedCubicMeasure:
      load
      OrderNo,
      (sum(Width) * sum(Length) * sum(Height))/1728 as 'Cubic Space'  //row 1
      resident ProcessingCubicMeasure group by OrderNo;


      drop table ProcessingCubicMeasure;

       


      for this code, what i want to do is to show the % of cubic feet our truck had loaded in any given period.

      basically, if there are 4 boxes in one day, and each of them is 1 x 1 x 1, then the total cubic feet for the day should be (1+1+1+1) x (1+1+1+1) x (1+1+1+1).

       

      help thanks!