4 Replies Latest reply: Apr 21, 2017 9:15 AM by LAURENT CLOATRE

# Calculation by each date

Hi,

Table1:

Group, Date, Value1

Group1, 01/01/2017, 100

Group1, 01/04/2017, 0

Group1, 01/05/2017, 0

Group1, 01/07/2017, 30

Group1, 01/10/2017, 0

];

I need create calculation by each date something like this

=Previous(Value1)+Value1-Previous(Value1)/(Days-1)

As result

Group, Date, Value1

Group1, 01/01/2017, 90

Group1, 01/02/2017, 80

Group1, 01/01/2017, 70

Group1, 01/04/2017, 60

Group1, 01/05/2017, 50

Group1, 01/06/2017, 70

Group1, 01/07/2017, 52.5

Group1, 01/08/2017, 35

Group1, 01/09/2017, 17.5

Group1, 01/10/2017, 0

Thx.

• ###### Re: Calculation by each date

Would be grateful for any help.

• ###### Re: Calculation by each date

Max - Could you explain the logic to us?

• ###### Re: Calculation by each date

I need some burndown process there.

Each date has to show value which is less then previous by some calculated formula.
For example we have value 100 on 01/01/2017

Period is 01/01/2017 till 01/10/2017
So total are 10 days.

I need this

1st day = 100-100/10 = ValueDay1

2nd day = ValueDay1- ValueDay1/(10-1) = ValueDay2

3nd day = ValueDay2-ValueDay2/(9-1) = ValueDay3

and the same till the end of period

• ###### Re: Calculation by each date

Hi,

This my example.