Cumulative Sum future

[#1]

Hi,

It's possible to have a table like this:

Year	Profit %	Value
2014	10	1000,00
2015	20	???
2016	10	???
2017	10	???
2018	30	???
2019	15	???

I have the initial value 1000 and the possible future profit in %, and i want to calculate the value for the future

for 2015 the value is 1000 + 10%=1100

for 2016 the value is 1100+20%=1320 etc etc

the complete result from excel is here:

Year	Profit %	Value
2014	10	1000,00
2015	20	1100,00
2016	10	1320,00
2017	10	1452,00
2018	30	1597,20
2019	15	2076,36

Thanks,

GM.

[Gysbert_Wassenaar]

Perhaps like this:

LOAD
     Year,
     [Profit %],
     alt(peek(Value),Value)*alt(previous(1+[Profit %]/100),1) as Value 
INLINE [ 
    Year, Profit %, Value
    2014, 10, 1000
    2015, 20
    2016, 10
    2017, 10
    2018, 30
    2019, 15
];

[alexandros17 · Accepted solution]

E' possibile ottenere lo stesso risultato nell'oggetto visuale (la tua tabella) attraverso l'istruzione "Above",

dagli un'occhiata e se hai bisogno di aiuto contattami. ....

Ciao