14,970,515 members
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
Updated 2-Feb-14 19:50pm
v2

## 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 ;
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"