How to calculate sum in crystal report

Question

0.00/5 (No votes)

See more:

The report i want to create is

       1 3 5
       2 4 5
Total: 3 7 10

What I have tried:

I tried the summary and the running total function in the crystal report field explorer
and chose sum but it just counts the number of the records
what can be the possible problem
or alternate solutions to compute the sum of the values in the crystal report?

Posted 11-Oct-21 22:59pm

Beginner213456

Updated 12-Oct-21 6:18am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2021-10-12T06:18:00

Solution 1

See the responses to this CP post HOW to sum column in crystal report[^] or any of the links in the "Related Questions" list to the right of this post.

If you are just getting a count of the number of records then you have forgotten to change the operation to "Sum" from the default "Count"

Posted 12-Oct-21 6:18am

CHill60

Comments

Beginner213456 12-Oct-21 21:36pm

No, i definitely changed it to sum.
i also tried doing it in the formula and added the formula
Sum({table.Field}) but it says: a number field and a curruncy amount field is required here

CHill60 13-Oct-21 11:39am

table.Field is a numeric type (not a string)?

Beginner213456 14-Oct-21 3:19am

Yes, the fields I want to be calculated are integers

Beginner213456 12-Oct-21 22:29pm

The same if i change it to Average and etc.