26 Replies Latest reply: Aug 10, 2018 2:45 PM by Sunny Talwar RSS

    % increase from last month

    Ashley Kuttler

      Hello,

       

      I have an expression for total payments :

      (Sum({<Account={'2000','2001','2002','2003'}>}Trans))*-1

       

      How would I create a measure for % increase in payments from previous month?

      I want this to be rolling dates as I load new data every month. So I want...(total for last month-total for current month)/ Total for last month).