Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to do the following expression :
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.
For Cumulative Total
RangeSum(Above(SUM(Sales),0,RowNo()))
or
RangeSum(Above(TOTAL SUM(Sales),0,RowNo(TOTAL)))
Replace SUM(Sales) with your Expression.