Summarizing the contents of a field?

[ElGordo123]

I'm very new at Crystal (and formulas in general) and need help. I have a field [PUNIT] that contains numerical data (01-543, 02-8012, etc), I want to be able to have a summary that counts how many units begin with 01, how many begin 02, how many begin 03, etc.

How is this done in Crystal? Also, can anyone recommend a book or site that may be useful in learning formulas (like formulas for dummies )

Thanks for any response in advance.

 

[FoxG]

Hi,

To strip off first two digits, create formula...

left({PUNIT},2)

Then group on the formula you've just created

Use the Insert Summary option for a field which is unique to each record (Right Click on the field in the details).

This will automatcally produce the totals you require.

Hth,
Geoff

 

[kenhamady]

Or you could add a cross-tab using that formula as the row field and the summarized field. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[ElGordo123]

Thank you very much for the responses. Problem solved!