Sum A Group Field

[Wes98765]

I am very new to Crystal. I have a group from the database and I need to add it together with the groups second value. How do I do this? I tried to create a formula and use Sum(Group #6) but it does not work.

Thanks

Wes

 

[Ngolem]

you don't describe your problem very well

is your report structure like this

Group 1 header
Group 2 header
details
Group 2 footer
Group 1 footer

And you want the {sum of table.Group1value } added to each value of some value in Group 2?

If you reverse the groups it would be simpler then it is simple addition.

I cannot see that the Group 1 value being the actual value summed....show us a numeric example of what you are trying to do.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[Wes98765]

Can I email you a temp db with 3 recs and the report I really don't know what I am doing. I have a cash register program with 3 main tables. 1 is Ticket Table that has total values and 2 is saleshistory which has multiple items for each ticket. The last on is the problem. Table returned Items lists any item that was returned All I need to do is show totals which I have - the total returned items. I can't get the returned Items to Stop displaying multiples.

Thanks,

Wes