4 Replies Latest reply: Oct 26, 2017 12:06 PM by Maria Gonzalez RSS

    Calculation each Line of Order and Sum the total

    Maria Gonzalez

      Hello,

       

         I need to calculate the total Boxes; the calculation is by each LineNumber (Quantity / CapacityBox)  then Sum the result for each line . I did with the next variable, but my result looks different, I insert into the table the calculation is by LineNumber, however I need to have the total calculation into variable.

       

      Sum({<Numero_Linea={*}, [PROYECTO ESPECIAL]={'N'}, Año={$(vAñoActual)}, _Id_Flag={0}, Estatus_Cobranza= {'EN SURTIDO','FACTURADO','ENTREGADO','CONSOLIDADO'}, TipoDeEntrega -= {'SOLO FACTURA'} >}Cantidad)

      /

      Sum({<Numero_Linea={*}, [PROYECTO ESPECIAL]={'N'}, Año={$(vAñoActual)}, _Id_Flag={0}, Estatus_Cobranza= {'EN SURTIDO','FACTURADO','ENTREGADO','CONSOLIDADO'}, TipoDeEntrega -= {'SOLO FACTURA'} >}Cant_PzasxCajas)


      Sum the Total for Each Line Estimated = Quantity / CapacityBox

       

      Table&amp;KPI.JPG

      Somebody can help me?

      Thank you!