0 Replies Latest reply: Oct 5, 2012 10:59 AM by jagan mohan rao appala RSS

    Calculating AR

    jagan mohan rao appala

       

      Hi All,

       

      I stuck with an expression in calculating the AR, please check the data below

       

      Invoice#Transaction Date
      Transaction#Balance

      100

      1/1/201210001000
      1001/10/20121005900
      1002/10/20121010800
      1012/10/201210205000
      1012/15/201220124000
      1012/10/201220153000
      1012/10/201220201000

      I am providing a Date object to select As of Date.  Based on the selected date, i need to sum up the balance field by getting the amount Maximum Transaction# of an invoice. 

       

      Suppose if I selected date as 2/10/2012, for Invoice# 100 the AR is 800.

      Suppose if I selected date as1/20/2012, for Invoice# 100 the AR is 900.

       

        I have around 10 million invoices, so if I use Aggr() it is taking to much time to load the chart.  Is there any other method to do this.  I also tried FirstSortedValue(), but it is given me correct values when I used Invoice# as dimension, but my chart has no Invoice# dimension.

       

      Regards,

      Jagan.