Print Page | Close Window

help in summing fields

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11528
Printed Date: 03 May 2024 at 1:48am


Topic: help in summing fields
Posted By: Greg2010
Subject: help in summing fields
Date Posted: 26 Oct 2010 at 11:59pm
I have a report that summarizes by date, which works fine, but I now need it to sum by "county-(where the goods came from)" before summing by date and need to figure out how to do that
In the detail line I have the following formula field "PADEP_MUN"
if {IPDETAIL.WCLASS} = '01'  then Round({@Tons},4) else 0
 
In my group footer, I have the following formula field "L_PADEP_TOT_MUN"
ROUND(SUM({@PADEP_MUN}, {INBOUND.DATE},"monthly"), 1)
 
There is already an existing group header of INBOUND.DATE
 


Print Page | Close Window