How to calculate sum of Formula Filed in crystal report?

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I am using crystal report.
In that i have taken sum of some filled (@tot).

And also i want to take sum of the @tot, when i want to take sum of the @tot as like Sum({@tot}) it gives error.

Tot i used this formula
{VendarMaster.kapat}*Sum ({SankalanBufMaster.bufmilk}, {SankalanBufMaster.venno})

Here is the format of my report,

Name AVG TOt
ZYX 100 100

ABC 150 150

Total 150

But here i want the total=250

How to calculate sum of @Tot?

Thank You,

Posted 2-Feb-14 19:45pm

basurajkumbhar

Updated 2-Feb-14 19:50pm

v2

Add a Solution

2 solutions

Solution 1

Use Summary Field[^]

Posted 2-Feb-14 20:03pm

thatraja

Add a Solution

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

basurajkumbhar · Accepted Answer · 2014-02-03T01:32:00

Solution 2

Create a formula like this.and place it in group header

Shared numbervar tot;
Shared numbervar grandtot;
Shared numberVar ftot;
tot :={ VendarMaster.kapat}*Sum ({SankalanBufMaster.bufmilk}, {SankalanBufMaster.venno});
grandtot :=grandtot + tot;
ftot:=grandtot-tot;
ftot ;

Posted 3-Feb-14 1:32am

basurajkumbhar

Comments

sumit WanZa 16-Feb-14 0:35am

SIR GOT ERROR IN
THE FIELD NAME IS NOT KHNOW

sumit WanZa 16-Feb-14 0:36am

I HAVE ONLY ONE FIELD
FIELD NAME id amount
i want to total only amount filed
and my table name is 'vadhavo' and field name is 'amount'

basurajkumbhar 21-Feb-14 8:11am

Hi Sumit,

You have filed name id amount and you want the sum of the id amount ok..
go to your report right click on report and Insert then Summary and choose the filed which the you want the sum like "id amount"

I hope this will help you....

How to calculate sum of Formula Filed in crystal report?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

How to calculate sum of Formula Filed in crystal report?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us