3 Replies Latest reply on Jan 28, 2018 5:35 PM by Zhouyi Zhang

    % Complete Calculation

    Sargam Gupta
      Order No.ProductStatusPoint
      1beddelivered 4
      couchDelivered 4
      tableShipped3
      chairnew3

       

       

      I need to calculate % complete for the order number 1.

      Calculation for complete will be

      (total number of points for status 'Delivered' / total number of points)*100

      The value should be 57%