Joined: 24 Jan 2009
Online Status: Offline
Posts: 5
Topic: Running Total Field Question Posted: 04 Mar 2009 at 12:29pm
Heya Guys
I have created a cystal report that has a running total field on a cost
entry on the report. The data comes from a database where the field
type is set to numeric with two decimal places. However when i run the
report it doesnt add up the total at all it just brings up 13 (unknown
where it gets this from as the value is in the thousands.
The running total field is set as follows:
Summary type = Count
Summary Field = TotalCost
Evaluate = For Each Record
Reset = never
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 09 Mar 2009 at 6:50am
which value? the total of the TotalCost or the number of records? I don't use running totals, but it appears that you want the count of records (that is what you told the running total to do). From the complaint, it sounds like you want the Summary Type to be Sum, but I am not sure.
Joined: 24 Jan 2009
Online Status: Offline
Posts: 5
Posted: 09 Mar 2009 at 8:21am
Yea I want to work out the total of all the fields called totalcost. I thought that it would be sum however ther isn't a sum summary option. Is this because I am using the .net version?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 09 Mar 2009 at 12:27pm
What data type is TotalCost? It needs to be a numeric field in order for Sum to be an available option. Also, you need to select the field before you select the summary type, otherwise you may not see all of the options.
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
IP Logged
