1 Reply Latest reply: Jan 9, 2013 7:30 AM by Fredrik Svensson RSS

    Performance issue

      I wonder how you could optimize the following expression:

       

      Sum(If(Aggr(NODISTINCT Max([Date of Est.]), ID,[Year Quarter of Est.]) = [Date of Est.], COST))

       

       

      I have 18 million rows, created by using a interval function, but where I have several rows within the same period of time.

      But for the moment I am experiencing very slow response by using the above expression.

      Anyone faced the same problem?