problem with summation of all raw tuple and display in last column dat

[ub1234567]

Hi Group Members,

below is my problem.

need output like :

Accessory Research_amt Plant_amt health_amt total_amt
Staff 10 20 15 45

so i need summation of all tuple raw amount in last column raw - same tuple.

Research_amt , Plant_amt , Health_amt each one has function to calculate amount.

total_amt has also function that has parameters and called
above three function and summation of all stors in out variable of total_amt function.

out_total_amt := f_research(----parameter--) +
f_health(---parameters---) +
f_Plant(---parameters---)

my problem is that when i add all three function values and stored in variable it vgives me value 0, even though they have all positive values.

but when i add any one function values and stores in variable
then it display that values.

Any helps is greatly appriciated.

Thanks.

 

[Madawc]

Maybe you need an extra field for display, something like

whileprintingrecords;
NumberVar out_total_amt

I also think you could get the same result more easily by doing summary totals of the three values and then adding them in a formula field. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

It sounds like these values appear in different detail rows. If you want the summary at some group level, then you probably need a formula like this in the group footer:

sum([sum({@researchamt},{table.groupfield}), sum({@plantamt},{table.groupfield}),sum({@healthamt},{table.groupfield})])

-LB