Cummulative Expression

[suvechha_b]

Hi ,

How to build the following chart :

Input
Trading Day	1	2	3	4	5
Sales	500	1000	2000	500	1000
Budget	0	0	20000	0	0
Budget=20000/5 is 4000
Output
Trading Day	1	2	3	4	5
Sales	500	1500	3500	4000	5000
Budget	4000	8000	12000	16000	20000

Please find the attachement sample

In the sample model . I am using vPerFormula and vPerFormulaBud to calculate the sales and budget resp.

[suvechha_b]

Input
Trading Day	1	2	3	4	5
Sales	500	1000	2000	500	1000
Budget	0	0	20000	0	0

where Sales is calculated with the help of variable , eg , vSales

vSales = sum({$<TranType = {'Sales_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

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

Can anyone tell me how to write the following expression :

LOAD Sum(Budget)/Count(Budget) as Budget1

as vBudget / count(vBudget ) is also not working

and

Method 2 is RangeSum(Above()) Method:

=RangeSum(Above(vSales ), 0, RowNo()))

=RangeSum(Above(vBudget), 0, RowNo())) are not working

Re: need to get the cummulative sum

[sunny_talwar]

Wow! this is huge file. Were you not able to reduce the application size for uploading purposes?

[maxgro]

The file is too big.

What if every question has an attachment of some hundred megabytes?

[suvechha_b]

Sales Value is calculated a variable  :

vPerFormula : sum({$<TranType = {$(vAmountType)},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Budget Value is calculated a variable  :

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

How to use this variables in the cummulative sum .

as Sum(Budget)/Count(Budget) as Budget1

and

Method 2 is RangeSum(Above()) Method:

=RangeSum(Above(Sum(Budget1), 0, RowNo()))

=RangeSum(Above(Sum(Sales), 0, RowNo()))

Re: need to get the cummulative sum

Re: need to get the cummulative sum