23 Replies Latest reply: Jul 6, 2017 12:05 AM by Amit Saini RSS

    Cumulative Sum Help!

    Amit Saini

      Hi Folks,

       

      I need to cumulative sum on bar chart , below is my expression:

       

      =num(Money(sum(aggr(sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), CurrencyIsoCode, Month))/1000000),'####')

       

      I'm trying Something like below , but it's not working:

       

      =aggr( rangesum(above( sum(fcur_PeakAnnualRevenue__c)/sum( distinct Rate), 0, rowno() )), CurrencyIsoCode, Month)

       

      Thanks,

      AS