LearningCrystal2010
Technical User
I have 2 reports that I need to somehow show the same amounts for and wanting the monthly report total to match the quarterly report for that month.
The issue is with the rounding along with grouping differently between the 2 reports
Example: October data
County Tons Date Trans#
AB 2.48 10/01/09 521522
AB 2.25 10/15/09 530575
AB 2.34 10/15/09 530576
BC 2.76 10/02/09 522278
BC 2.85 10/03/09 524785
BC 4.74 10/03/09 524794
a. Monthly report - Example (October)
County Tons (Rounded to the tenth place)
AB 7.1
BC 10.4
____
Total 17.5
The Monthly reports are grouped and summarized by county
Formula: ROUND(SUM({@Tons},{COUNTY.ID}), 1)
b. Quarterly report - Example
Month Total Tons (Rounded to the tenth place)
October 17.4
November 22.3
December 14.5
The Quarterly reports are grouped and summarized by date
Formula: ROUND(SUM({@Tons}, {RECORD.DATE},"monthly"), 1)
The issue is with the rounding along with grouping differently between the 2 reports
Example: October data
County Tons Date Trans#
AB 2.48 10/01/09 521522
AB 2.25 10/15/09 530575
AB 2.34 10/15/09 530576
BC 2.76 10/02/09 522278
BC 2.85 10/03/09 524785
BC 4.74 10/03/09 524794
a. Monthly report - Example (October)
County Tons (Rounded to the tenth place)
AB 7.1
BC 10.4
____
Total 17.5
The Monthly reports are grouped and summarized by county
Formula: ROUND(SUM({@Tons},{COUNTY.ID}), 1)
b. Quarterly report - Example
Month Total Tons (Rounded to the tenth place)
October 17.4
November 22.3
December 14.5
The Quarterly reports are grouped and summarized by date
Formula: ROUND(SUM({@Tons}, {RECORD.DATE},"monthly"), 1)