Sum Formula Needed

[dbielenda]

This is easy I am sure...

I want to sum a field according to each individual warehouse that I have.

I used the forumla: Sum ({Tablename1.Field1},{Tablename2.Field2})

{Tablename1.Field1} is the sume value I need and the {Tablename2.Field2} is the warehouse I need the sum to match up with. I get an error telling me that the summary could not be created. Do I need to group?

Thanks for any help s-)

 

[SmpTraining]

The logical answer is to group by WH then sum the field as you suggest. Steve Phillips, Crystal Consultant

 

[dgillz]

Dbiellenda,

Sums in crystal are not created by formulas, they are created by grouping.

To do what you want, place {Tablename1.Field1} in the details section of your report. Then right click on it and select "Insert Summary" when the bext dialog box comes up, make the summary by {Tablename2.Field2}.

Let me know if this works Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[dbielenda]

DGillz,

I grouped by the warehouse then right mouse clicked, did Insert, however, there was no option for "sum". The only options were: maximum, minimum, count, distinct count, Nth largest, Nth smallest, mode, and Nth most frequent. Did I do something incorrectly?

Thank you for your response s-)

 

[dgillz]

Dbielenda-

I'm confused, you have to right click on the database field first, then insert summary.

If you are doing this and SUM is not an option, then most likely your field is not a numberic field. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[dbielenda]

DGillz,

I see the issue I had. I resolved it. Thank you very much for your help!!!!!!! s-)

 

[csm2]

dbielenda,
It would be salutary if you would inform us how you resolved your issue. Others might have the same or similar issue.

 

[dbielenda]

csm2,

I grouped by the warehouse. Then the numeric field that I needed summed (being quantity on hand), I right clicked on the field --> Insert --> Summary then summed it according to the individual item in that warehouse since there were all unique items in this warehouse. Did that make sense?

Hope that helped. s-)