1 / 9

Grouping by Weeks in a Crosstab

Carrie Duran, Sr. Systems Analyst at UTS/Administrative Information Systems, presents a crosstab report grouping data by weeks. The report filters transactions that occurred on Thursdays and calculates the transactions for a week starting from Thursday. The report covers the period from 01-FEB-2011 to 28-FEB-2011. For any questions or further information, please contact carrie.duran@du.edu.

lbrooks
Download Presentation

Grouping by Weeks in a Crosstab

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Grouping by Weeksin a Crosstab Carrie Duran Sr. Systems Analyst UTS/Administrative Information Systems

  2. WHEN abs(_days_between([TRANSACTION_DATE],next_day([TRANSACTION_DATE],'THURSDAY'))) = 7 THEN ([TRANSACTION_DATE])

  3. WHEN abs(_days_between([TRANSACTION_DATE],next_day([TRANSACTION_DATE],'THURSDAY'))) = 6 AND _days_to_end_of_month([TRANSACTION_DATE]) > 6THEN (_add_days([TRANSACTION_DATE],6))

  4. From Date >= 01-FEB-2011 AND To Date <= 28-FEB-2011

  5. Wrap up/Questionscarrie.duran@du.edu

More Related