Here's my situation. I need to create a budget report based off my general ledger numbers. The numbers are setup as xxx.xxxx. Crystal only sees the first 3 numbers when I browse the data field. In order to see the .xxxx I need to format the number field in the report. My problem is the numbers after the period are the department numbers. I need a report to show the budgets by department. So far I've created a group based off the GL title. This provides a list of all departments for a specific "title" name, i.e. Auto Expense. How can I create a report to show all of the department totals using the .xxxx portion of the GL number? I'm sure I need to use a formula but not what formula would best fit this question. Any help would be appreciated.
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
,4)