Crystal Report this field can not be summarized error on forumla field

[Former Member]

hi,

I create one Formula for calculate the amount

For example -

SR.NO	Rate	Qty	Amount
1	10	10	100
2	5	5	25
TOTAL		15	125

here i calculate Amount using crystal report formula field i.e - ( Rate * Qty)

i want to Sum of Amount Column like SUM(@Amount);

they show this field can not be Summarized error.

please give me solution for solving this problem

thanks!!!

Rly fast

[Former Member]

Create a new Formula:(example : SumCal)

Shared numbervar summz :=0;

And place it in Report Header;

New Formula:

Shared numbervar summz;

summz := summz + @amount;

And place it in details next to where the formula @Amount is placed

Third Formula:

{@SumCal}

And place it in the footer. (This is the summary)

[abhilash_kumar]

Hi Kiran,

Are 'Rate' and 'Qty' fields formulas as well? If yes, what's the formula?

-Abhilash