1 2 3 Previous Next 34 Replies Latest reply on Jun 7, 2018 12:35 PM by rayvel.lopez

    Count each month greater than zero

    rayvel.lopez

      Hi

       

      I'm looking for LOD to get a count for the last 12 months if the charges are greater than zero.

       

      So far this is what I have

      if( DATEDIFF('month', [Transaction Post Date], TODAY()) <13  AND DATEDIFF('month', [Transaction Post Date], TODAY()) >= 1)

      then

       

      Thank you

       

       

      Example:

      YearMonthCharge AmountCount
      2017June$0.000
      2017July$0.000
      2017August$0.000
      2017September$0.000
      2017October$10.00 1
      2017November$150.00 1
      2017December$175.00 1
      2018January$200.00 1
      2018February$15.00 1
      2018March$30.00 1
      2018April$50.00 1
      2018May$75.00 1
      $705.008
        1 2 3 Previous Next