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.
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>
Member
50 Points
97 Posts
Sum of Total in Crystal Report
Mar 04, 2014 01:03 AM|Pradip26|LINK
I want Grand Total value in Crystal Report Using Formula
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 03:15 AM|aspsak|LINK
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.
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 03:41 AM|Pradip26|LINK
As per U Say using First Option. It's Disply Total Count Of Record In Report
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 03:49 AM|aspsak|LINK
http://csharp.net-informations.com/crystal-reports/img/csharp-crystal-report-summary-insert.GIF
please see the above image as reference.
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 03:56 AM|Pradip26|LINK
Thanks For ur reply
How i can Do for x+1 Total.
I insert tale field field. so they disply total count
Contributor
6622 Points
1743 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 04:05 AM|Ajay2707|LINK
HI Pradip,
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://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.businessobjects.integration.eclipse.doc.crdesigner/reportdesigner/crurfinsertsummarydialogbox.htm
http://stackoverflow.com/questions/4508319/formula-to-sum-amount-column-in-crystal-report
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7034
http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20242
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 04:30 AM|Pradip26|LINK
use the formula
sum(tonumber({Trans.field}));
Requred Field Here Error Occurd
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 04:33 AM|aspsak|LINK
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.
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 04:40 AM|Pradip26|LINK
Sum(FieldName)+1
use this But field required Here Error
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 04:46 AM|aspsak|LINK
FieldName is your report field name
refer this image
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 05:04 AM|Pradip26|LINK
The String is non numeric
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 05:10 AM|aspsak|LINK
Sum(toNumber(FieldName))+1
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 05:17 AM|Pradip26|LINK
Required Field Here
Member
594 Points
386 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 05:41 AM|aspsak|LINK
can you post report formula editior image.....
Contributor
6622 Points
1743 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 06:37 AM|Ajay2707|LINK
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>
Member
50 Points
97 Posts
Re: Sum of Total in Crystal Report
Mar 04, 2014 11:04 PM|Pradip26|LINK
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.