Log In
Register
Home
August 17, 2019
Offline
Hi,
I am trying to figure out how to fill down values by groups. I have around 50 accounts (groups) with their balances (values) available only for working days. What I would like to achieve is to fill down account balances also for non working days. I prepared a sample file containing several days and two groups A and B. Finally the time period might begin with non working days, after filling down a fill up should be the last step.
I spent some time searching internet for a solution and I also went throug the forum here but I did not find the one that suit me. Any advice is welcomed.
Thanks Pavel
July 16, 2010
Online
Hi Pav,
What is the logic for filling up vs filling down? Is it related to whether the date is the first of the month or whether there are two gaps vs one gap?
Mynda
August 17, 2019
Offline
Hi Mynda,
that is a good point and I think the fill up might be omitted. I want to calculate the average account balance in a period of time, which is a month, but it does not start with the beginning of the month and does not end with the end of the month. I have account balances available only for working days, not weekends or holidays, to calculate the average I need to fill down these days with the account balance of the first prior working day, the first prior available balance. Fill down is just fine. The fill up was just in case the very first period starts with a non working day but this might be solved by shifting the calendar back by one or two days in order to have not null value for the very first day.
Thanks Pavel
1 Guest(s)
