on 10-01-2014 7:32 PM
Hi
I have a data set at day level such as;
Date | Value |
---|---|
01.10.2014 | 563,12 |
02.10.2014 | 321,89 |
03.10.2014 | |
04.10.2014 | |
05.10.2014 | |
06.10.2014 | |
07.10.2014 | |
08.10.2014 | 212,31 |
09.10.2014 | 534,21 |
I want to repeat the last value for the days which don't have any value.
Date | Value |
---|---|
01.10.2014 | 563,12 |
02.10.2014 | 321,89 |
03.10.2014 | 321,89 |
04.10.2014 | 321,89 |
05.10.2014 | 321,89 |
06.10.2014 | 321,89 |
07.10.2014 | 321,89 |
08.10.2014 | 212,31 |
09.10.2014 | 534,21 |
Is it possible with any function usage?
Thanks!
=If(IsNull([Value]);Previous(Self);[Value])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried "Previous" function. However it just writes to first date (03.10.2014) but doesn't repeat it.
=If(isnull([value]);previous([value]);[value])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.