Cummulative sum on Total

[suvechha_b]

Hi,

Can anyone help me to write the following expression :

Budget Value is calculated with the following variable :

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

I need 1047369499/26

1. i.e Total Budget Value / Trading Day =    40283442.26

So,

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

..

..

..

..

Trading Day 26 : 1047369499

[Gysbert_Wassenaar]

Create another variable

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

Use that variable in your chart expression: = $(vPerFormulaBudTotal) / (27-[Trading Day])

[suvechha_b]

Sales Vaue is working correct by using straight table and full accumulation.

But my requirement is in Budget Value :

Output :

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

..

..

..

..

Trading Day 26 : 1047369499

[suvechha_b]

No its not working .

[suvechha_b]

No its not working .

It looks like the following image :

But my requirement is in Budget Value :

Output :

Trading Day 1 : 40283442.26

Trading Day 2 : 80566884.52

..

..

..

..

Trading Day 26 : 1047369499

[Gysbert_Wassenaar]

Post a qlikview document that demonstrates the issue.

[suvechha_b]

I tried to pull data for particular product as my model is to long to upload.

PFA.