6 Replies Latest reply: Feb 3, 2015 12:44 PM by Sujan Janardhan RSS

    Creating a Cumulative LY vs CY



      I am trying to generate a graph with Cumulative values by month for CY vs LY.


      For CY i am using below and it works fine(Working)


      Sum({< DateNum={">=$(=Num(YearStart(Today(),0,10)))<$(=Num((Today())))"}

      ,OpportunityStageName ={'Closed Won'}>} [Weighted_Booking__Amt]/1000000),0,rowno()))

      For LY I am not getting the rite result(Not Working)


      (Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Today()-365,0,10)))<$(=Num(Yearend(Today()-365,0,10)))"}

      ,OpportunityStageName ={'Closed Won'} >} Weighted_Booking__Amt/1000000)),0,RowNo())


      Please help.