Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Expression for cummulative sum

How to do the following expression :

snap.PNG

Trading Day  :                  New

       3                            4314965

       4                            8629930

...

...

...

         19                        81984344

and Total shoulbe also 81984344

I am using variables :

Column Budget : vBudget : sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Column New : vNew :  sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)/no_trading_days

Unable to upload sample model.

1 Reply
MK_QSL
MVP
MVP

For Cumulative Total

RangeSum(Above(SUM(Sales),0,RowNo()))

or

RangeSum(Above(TOTAL SUM(Sales),0,RowNo(TOTAL)))

Replace SUM(Sales) with your Expression.