I'm having troubles trying to figure out a pace when I have data for the first of the month...
Example:
I have data for the first of the month but need to calculate Pace...
So I have
2009-01-01.......2009-10-01
I can't figure out syntax to get me the total number of days from Jan to Oct based on the date dimension.
The user can select Jan - Dec, so I need the ability to handle the pace when the user only selects Jan - March, etc.