9 Replies Latest reply: Aug 4, 2015 4:20 AM by jagan mohan rao appala RSS

    Calculation

    Stacey Pillay

      Hi guys,

       

      I have the following table and would like to aggregate the table as per the below:

       

      Split by:
      - State1- customers who have a days past due greater than the previous period
      - State2 customers who have a days past due less than the previous period
      - State3 - customers who moved from any arrears to current (0 Days)
      - State4- customers who have a days past due that remains the same as the previous period

       

         

      Period Days Due
      120
      230
      360
      40