Question: Calculating Average Balance for Actual Days Outstanding

Fri, 10 Aug 2012 02:37:53 GMT

Hello all, need your help.

I have an app that needs to calculate the average loan balance outstanding for the month. However, I cannot simply take the average of the sum of the daily balance and divide by the number of calendar days in the month, since these loans are only outstanding for a few days--it is a stock lending operation. What I need is to calculate the balance only for the days that the loan is actually outstanding during the month.

I developed this generic example. I copy and paste an image below, and also attach this example as an Excel file.

As shown, I want the Actual Average by Days Outstanding in Row 36. This Average I calculated using CountIF in Excel. I don't know how to do so in QlikView.

Any advice and comments would be welcomed.

Thanks.

topic Question: Calculating Average Balance for Actual Days Outstanding in QlikView

Question: Calculating Average Balance for Actual Days Outstanding