Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Would be grateful for any help.
Max - Could you explain the logic to us?
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
Hi,
This my example.