6 Replies Latest reply: Mar 15, 2017 12:26 PM by Marco Barroso RSS

    Excluding ranges from linest_m() + linest_b()

    Marco Barroso

      Liner Trend expression:

       

      linest_m(total aggr(if(sum(PaidAmount),sum(PaidAmount)),DateOfService),DateOfService)*MonthOfService

      +

      linest_b(total aggr(if(sum(PaidAmount),sum(PaidAmount)),DateOfService),DateOfService)

       

      I need to exclude the last three months from the linear trend only. How can this be done ? I've tried set analysis after the aggr function, but may be doing something wrong.

       

      See attached example: 2017-01,2017-02, 2017-03.

       

      Regards