3 Replies Latest reply: Sep 18, 2014 5:33 AM by Manish Kachhia RSS

    divide with 2 collumms/tables in 1

      Hi guys,

      can you tell me how can I divide with 2 tables ?

      example:

       

      Tab1:

      Load DocNo,

           ArtNo,

           Cost, // here are amounts that costs with discount like: 550€ & -50€

           Quantity, //here are all quantity like 25 and 25

      FROM ..

       

      Now I want to sum(cost)/sum(quantity).

      Is it possible to use it in script?

      Backend in expressions, it works.