Formula

[Jeffcis]

Hi,

My table shows the following information:
Bc Name m2 Sales
HO CarpetOne 100.00 $1,500.00
LI Crampton Carpets 100.00 $1,500.00
NP Crampton Carpets 100.00 $1,500.00
NP Crampton Carpets 100.00 $1,500.00
TU Crampton Carpets 100.00 $1,500.00
HE Jacobsen Creative Surfaces 100.00 $1,500.00
HE Jacobsen Creative Surfaces 100.00 $1,500.00
HO Jacobsen Creative Surfaces 100.00 $1,500.00
HO Jacobsen Creative Surfaces 100.00 $1,500.00
LI Jacobsen Creative Surfaces 100.00 $1,500.00
NP Jacobsen Creative Surfaces 100.00 $1,500.00
HE Nuplex Industries Limited 100.00 $1,500.00
HE Nuplex Industries Limited 100.00 $1,500.00
HE Nuplex Industries Limited 100.00 $1,500.00
HO Nuplex Industries Limited 100.00 $1,500.00
HO Nuplex Industries Limited 100.00 $1,500.00
NP Nuplex Industries Limited 100.00 $1,500.00

Requirements: I need a formula to sum the 'm2' and the 'sales' by 'Customer name' and by BC. The second formula will be to total the 'm2' and the 'sales' by 'customer name'.

Result:
Bc Name m2 Sales
HE Jacobsen Creative Surfaces 200.00 3,000.00
HO Jacobsen Creative Surfaces 200.00 3,000.00
LI Jacobsen Creative Surfaces 100.00 1,500.00
NP Jacobsen Creative Surfaces 100.00 1,500.00
total $600.00 $9,000.00
HE Nuplex Industries Limited 300.00 4,500.00
HO Nuplex Industries Limited 200.00 3,000.00
NP Nuplex Industries Limited 100.00 1,500.00
total 600.00 $9,000.00

Appreciate any help.

Jeffcis

 

[dgillz]

Right click on the field and insert a summary. I cannot give you more explicit instructions because you failed to provide your version of crystal.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Jeffcis]

i'm using CR 11

 

[dgillz]

Right click the first field you want to summarize and select insert, summary. Then pick insert group. Make customer name the group field. Repeat for the 2nd field (except the group will already exist). No formulas required.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

You need to insert two groups--the first one on customer name and the second on BC. Drag the group #1 name and the Group#2 name into the group #2 footer. Then insert summaries on the two fields at the Group #2 level and the group #1 level. Suppress the group headers and detail section.

-LB

 

[Jeffcis]

Before I posted this question, I have the report made exactly was has been described above.

Is there anyway I can do this with formulas?

 

[Jeffcis]

The reason I asked is because, I have another CR report but it is grouped by BC, and Region (eg NSW) but I wanted to include in this report selected customers only (eg Jacobsen and Nuplex). The idea is to combine the two reports into one single report.

 

[lbass]

I can't really visualize what the end result would look like. Please show sample results. In what sense would you be combining reports?

-LB

 

[dgillz]

You need to limit the records in the report to just these customers. What is your current record selection formula?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Jeffcis]

I've used the running-total with formula like the below on the change of group, but I get a ZERO result

{'GL_LOI_'.Payer} = '100440' and {'GL_LOI_'.BC} like ['he','ho','li','np','tu','vc']

//100440=Jacobsen//

 

[lbass]

You are not responding to questions. Please reread previous posts.

-LB