 ## 15 replies

Last post Mar 04, 2014 11:04 PM by Pradip26

• ### Sum of Total in Crystal Report

I want Grand Total value in Crystal Report Using Formula

• ### Re: Sum of Total in Crystal Report

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.

Help to each other
• ### Re: Sum of Total in Crystal Report

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

• ### Re: Sum of Total in Crystal Report

Help to each other
• ### Re: Sum of Total in Crystal Report

How i can Do for  x+1 Total.

I insert tale field field. so they disply total count

• ### Re: Sum of Total in Crystal Report

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

• ### Re: Sum of Total in Crystal Report

use the formula

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

Requred Field Here Error Occurd

• ### Re: Sum of Total in Crystal Report

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.

Help to each other
• ### Re: Sum of Total in Crystal Report

Sum(FieldName)+1

use this But field  required Here Error

• ### Re: Sum of Total in Crystal Report

FieldName is your report field name

refer this image

Help to each other
• ### Re: Sum of Total in Crystal Report

The String is non numeric

• ### Re: Sum of Total in Crystal Report

Sum(toNumber(FieldName))+1

Help to each other
• ### Re: Sum of Total in Crystal Report

Required Field Here

• ### Re: Sum of Total in Crystal Report

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

Help to each other
• ### Re: Sum of Total in Crystal Report

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.

<div>The formula is as follows.</div> <div> </div> <div>formula1:</div> <div> </div> <div>Local numbervar ThisTotal:=Maximum ({Query1.Score}, {Query1.Employee});
Shared numbervar MaxTotal:=MaxTotal+ThisTotal;
ThisTotal</div> <div> </div> <div>Formula2:</div> <div> </div> <div>Created another formula as follows.</div> <div>Shared numbervar MaxTotal</div> <div> </div> <div>I used the "Formula2" in crosstab summary field.</div> <div> </div> <div>Its returning 0. Am I missing any thing.</div> <div> </div> <div>Please refer http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7034 </div> <div>http://stackoverflow.com/questions/4508319/formula-to-sum-amount-column-in-crystal-report </div>