1 Reply Latest reply: Jul 28, 2017 8:34 AM by omar bensalem RSS

    Calculate average maturity on customer basis (sales dependent)

    selim kocak

      Hello there,


      I would like to take the average grade of customer-based futures sales bills as in the case of excel in the trade.


      Thanks in advance for your help






      customer ID    date    maturity    sales

      20434307    6.01.2017    5.07.2017    115

      20434307    6.01.2017    8.01.2017    339


      (maturity * sales / total(sales) ) ,custumerID