Grand total

[yousufkhan]

I have field1 in crystal rpt as average rete , field2 totqty and field3 is

average rate * totqty in report footer i want grant total of field3
in at the end of report at report footer can anybody help

[jggtz]

Insert Summary for Average Rate and TotQty fields and place them at Report Footer
Then insert a new Formula Field that calculate

Sum({Table1.AverageRate}) * Sum({Table1.TotQty})

and place it at Report Footer also
If you don't want to view the Summary fields you can Suppress them

(Change table and fields' name as needed)

JG

[yousufkhan]

average rate is not field name its a average rate of group field
i am grouping the records and taking its rate fields average rate

and then making multiplication of "Rate" fields average rate into totqty
as total amount of that group record now this group grand total
i want at report footer

[jggtz]

I figured something like that after I clicked the post button, sorry for the misunderstandig!

[yousufkhan]

any crystal guru pls guid me