2 Replies Latest reply: Jul 4, 2014 4:58 AM by Alessandro Saccone

# Cumulative Sum future

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.

• ###### Re: Cumulative Sum future

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
];
```
• ###### Re: Cumulative Sum future

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