# Sum of Total in Crystal Report

• ### Question

• User1297564232 posted

I want Grand Total value in Crystal Report Using Formula

Tuesday, March 4, 2014 1:03 AM

### All replies

• User-510141866 posted

There is two way

1. Select the Field in report and go to menubar  Insert->Summary->ok.  In this window we can select sum and place of the value such as report footer.

2. Create formula field such as Total_Value , Sum({YourSPName;1.Field}) simple you can double click on field in formula editior window. Then drag to place as you want.

Tuesday, March 4, 2014 3:15 AM
• User1297564232 posted

As per U Say using First Option. It's Disply Total Count Of Record In Report

Tuesday, March 4, 2014 3:41 AM
• Marked as answer by Thursday, October 7, 2021 12:00 AM
Tuesday, March 4, 2014 3:49 AM
• User1297564232 posted

Thanks For ur reply

How i can Do for  x+1 Total.

I insert tale field field. so they disply total count

Tuesday, March 4, 2014 3:56 AM
• User-578610739 posted

Just add formula to detail portion, now in group footer or report footer where you want summary, just add summary field of that variable.

http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20242

Tuesday, March 4, 2014 4:05 AM
• User1297564232 posted

use the formula

sum(tonumber({Trans.field}));

Requred Field Here Error Occurd

Tuesday, March 4, 2014 4:30 AM
• User-510141866 posted

So you want total+1, right?

if yes then  we need to add formula field, as I mentioned above.

Sum(FieldName)+1 , and drag into report.

Tuesday, March 4, 2014 4:33 AM
• User1297564232 posted

Sum(FieldName)+1

use this But field  required Here Error

Tuesday, March 4, 2014 4:40 AM
• User-510141866 posted

FieldName is your report field name

refer this image

Tuesday, March 4, 2014 4:46 AM
• User1297564232 posted

The String is non numeric

Tuesday, March 4, 2014 5:04 AM
• User-510141866 posted

Sum(toNumber(FieldName))+1

Tuesday, March 4, 2014 5:10 AM
• User1297564232 posted

Required Field Here

Tuesday, March 4, 2014 5:17 AM
• User-510141866 posted

can you post report formula editior image.....

Tuesday, March 4, 2014 5:41 AM
• User-578610739 posted

Hi Dear,

You need to cast if it give number to text : ToText() , ToNumber() . you can get other formula from formula workshop as image given above.

The formula is as follows.

formula1:

Local numbervar ThisTotal:=Maximum ({Query1.Score}, {Query1.Employee});
Shared numbervar MaxTotal:=MaxTotal+ThisTotal;
ThisTotal

Formula2:

Created another formula as follows.
Shared numbervar MaxTotal

I used the "Formula2" in crosstab summary field.

Its returning 0. Am I missing any thing.

Tuesday, March 4, 2014 6:37 AM
• User1297564232 posted

Create New Formula Fields
in this
ToNumber({tablename.fields})

Then
create New Running Total
In select u convert formula fields
and in check box select sum
then click Ok.

• Marked as answer by Thursday, October 7, 2021 12:00 AM
Tuesday, March 4, 2014 11:04 PM