Guest_imported
New member
- Jan 1, 1970
- 0
Will anyone here have the formula to get MTD and YTD fields in the Cognos reports?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reporting solutions
- Thread starter Guest_imported
- Start date
- Status
CognosProfessional
Programmer
yes, complicated, using many hidden calculated columns, too much info to put here, but I have done it a few times.
cp
cp
We have a calendar table on our database which holds data with respect to actual date, week number, day name, month name, year etc etc then we can link this to any other date on any other database table (using the actual date column in calendar) and use it as the basis for any date dimensions or calculations. The calendar table itself contains years of data from past and for future.
- Status
Similar threads