Feb 7, 2005 #1 kingduck MIS Oct 31, 2002 41 EG Hi All; How do i sum value in a group and reset the sum for a new group. So that each group has its total beneath it? Thanks in advance.
Hi All; How do i sum value in a group and reset the sum for a new group. So that each group has its total beneath it? Thanks in advance.
Feb 7, 2005 1 #2 lbass Technical User Feb 9, 2002 32,816 US Right click on the field->insert summary->sum->check "insert summary for all groups". -LB Upvote 0 Downvote
Feb 8, 2005 Thread starter #3 kingduck MIS Oct 31, 2002 41 EG Thanks LB for your reply The calculate combo does not have sum in it. it has maximum , minimum, count and other stuff but no sum. I am using crystal report for VS.NET 2002 Thanks Upvote 0 Downvote
Thanks LB for your reply The calculate combo does not have sum in it. it has maximum , minimum, count and other stuff but no sum. I am using crystal report for VS.NET 2002 Thanks
Feb 8, 2005 #4 lbass Technical User Feb 9, 2002 32,816 US What is the datatype of the field you are trying to sum? If it is a string with numeric text, then create a formula: val({table.string}) Then insert a summary (sum) on the formula. -LB Upvote 0 Downvote
What is the datatype of the field you are trying to sum? If it is a string with numeric text, then create a formula: val({table.string}) Then insert a summary (sum) on the formula. -LB
Feb 8, 2005 Thread starter #5 kingduck MIS Oct 31, 2002 41 EG Thanks LB. It was a numeric text Thanks very much Upvote 0 Downvote