cancel
Showing results for 
Search instead for 
Did you mean: 

Repeat previous value

former_member729889
Participant
0 Kudos

Hi

I have a data set at day level such as;

DateValue
01.10.2014563,12
02.10.2014321,89
03.10.2014

04.10.2014

05.10.2014
06.10.2014
07.10.2014
08.10.2014212,31
09.10.2014534,21

I want to repeat the last value for the days which don't have any value.

DateValue
01.10.2014563,12
02.10.2014321,89
03.10.2014321,89

04.10.2014

321,89
05.10.2014321,89
06.10.2014321,89
07.10.2014321,89
08.10.2014212,31
09.10.2014534,21

Is it possible with any function usage?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

arijit_das
Active Contributor
0 Kudos

=If(IsNull([Value]);Previous(Self);[Value])

former_member729889
Participant
0 Kudos

Thank you Arijit. "Self" declaration solved it all!

Answers (1)

Answers (1)

former_member729889
Participant
0 Kudos

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])