Calculation by each date

[maxsheva]

Hi,

Table1:

LOAD * INLINE [

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.

[maxsheva]

Would be grateful for any help.

[tamilarasu]

Max - Could you explain the logic to us? 

[maxsheva]

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

[lcloatre]

Hi,

This my example.