parrotheadman
Programmer
How can I write a formula that will summarize month to date activity on several different fields on a cross-tab report? Any ideas or examples would be helpful. I am on 8.0.1. Thanks.
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!
Month to Date Formula
- Thread starter parrotheadman
- Start date
- Status
synapsevampire
Programmer
Why do you want a summary, just drop the fields to summarize in the rows and use the date as the grouping (you can select whether the date field is used by day, week, month, etc. under the group options)
-k kai@informeddatadecisions.com
-k kai@informeddatadecisions.com
chelseatech
Instructor
There are date ranges that will give you MonthToDate and LastFullMonth - just use those. Editor and Publisher of Crystal Clear
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question