1 Reply Latest reply: Jan 31, 2017 10:24 AM by Marcus Sommer RSS

    Sumif question (dynamic ageing)

    Bassam Frem

      How to calculate the sum of the "Amount" field based on the number of delinquent days, grouped by month.

      Please see below

       

      Table fields

      Amount     1/14     2/14     3/14     4/14

      $100          4          34          64     90   

      $80          45          65          71     85

      etc.

       

      Desired output chart

      Month     0-30     30-60     60-90

      1/14        $100     $80      $0

      2/14        $0        $100     $80

      3/14        $0        $0         $180

      4/14        $0        $0        $180

       

      What should be the dimension and expression ?

       

      Thank you

      Bassam