Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: To Get sum of field in crystal report Post Reply Post New Topic
Author Message
buterfly0707
Newbie
Newbie


Joined: 11 Dec 2009
Location: United States
Online Status: Offline
Posts: 1
Quote buterfly0707 Replybullet Topic: To Get sum of field in crystal report
     Posted: 11 Dec 2009 at 3:49am
hi

 i have some problem while getting the sum of the field. i want to get the sum of one filed for example sum of the values which in Debit Field. but i want to get this sum according to another field called period. means for that respective period value i want the sum of the Debit field in crystal report. and im using a dataset.in this dataset there s both the fields

here, i know how to get the sum of the debit field by adding the Formula field. but i don't know how to take it according to value in my period field.

can someone help me with this.

thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 11 Dec 2009 at 7:12am
do you have a group from the period? if so, you can get the sum by using the 'summing' button or as a formula:
sum({table.debit}, {table.period})
 
the caveat is that there must be a group that is based on the second parameter of the sum function.
 
HTH
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum