19 Replies Latest reply: Apr 24, 2014 3:49 PM by Darrin Pilkington RSS

    Previous Month set analysis not working but with a twist.

    Darrin Pilkington

      The twist being that in my calendar I have created serial numbers for my months to simplify the going forward and back in time.


      Example, current month =52

      Each month from the start of my calendar counts from 1 on.


      I am trying t compare current revenue to previous month revenue with Set Analysis.


      The two formulas below, I believe should work based on my searches but both return 0.


      =sum({<TradMthSerial = {$(=max(TradMthSerial)-1)}>} RevenueAgent)



      =sum({<TradMthSerial = {$(=only(TradMthSerial - 1))}>} RevenueAgent)


      Thank you for you help.