Distribution dollar amounts:
Expand|Select|Wrap|Line Numbers
- Today (T) T+1 T+2
- 300 350 375
For example if the cumulative distribution is based on two days above we would have the following:
ie. 650 (9/26/07) would actually be inputted on 9/27/07 period.
Now my issue arises over weekends and holidays. I have performed a day count, which allows the query to tell me the exact number of days since the last update.
What I would like to do with that is calculate the cumulative total over the weekend as if I was running it on business day.
Below is my query with what I have so far. Any help would be greatly appreciated.
Expand|Select|Wrap|Line Numbers
- SELECT [Units Entries (GLDST-)].[Fund Number], Max([Units Entries (GLDST-)].[Compass Entry Date]) AS [MaxOfCompass Entry Date], Last([NAV's - ETF Income Adjustments (data)].UNITS) AS LastOfUNITS, Last(DateDiff("d",[Compass Entry Date],Date())) AS Daycount
- FROM [Units Entries (GLDST-)] INNER JOIN [NAV's - ETF Income Adjustments (data)] ON ([Units Entries (GLDST-)].[Compass Entry Date] = [NAV's - ETF Income Adjustments (data)].Date) AND ([Units Entries (GLDST-)].[Fund Number] = [NAV's - ETF Income Adjustments (data)].[Fund Number])
- GROUP BY [Units Entries (GLDST-)].[Fund Number];