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.