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

    Creating a Cumulative LY vs CY

    Sujan Janardhan

      Hi,

       

      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)

      rangesum(above(

      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)

      RangeSum(Above

      (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.