Populate several consecutive missing values based on previous weeks value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cgalea
5 - Atom
‎12-09-2021
09:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
Does anyone know how to fill in one or more consecutive missing values in a specific week with values taken from the previous week. Appreciate any help you can provide!!
Labels:
2 REPLIES 2
Sebastiaandb
12 - Quasar
‎12-09-2021
10:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastiaandb
12 - Quasar
‎12-09-2021
10:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cgalea ,
And here a different version that leaves row 9 and 10 null() if it's empty (like your example haha). I guess you want the first solution but i might be wrong :-).
Greetings,
Seb