Group by first letter of a field 1

[JCook23]

All of our invoices begin with H, C or 0. I want to do a group on armast.finvoice but only by the first letter. That way I can sum the amounts of all 'H' invoices, etc. How can I accomplish this?

Jeff

 

[bdreed35]

Create a formula that returns just the first letter of the field like this:

@Invoice_First_Letter

{table.invoice}[1]

Now create a new group and use the formula as the field.
If you have other groups already, you will need to move the group up in the grouping order so that it is where you need it to be.



~Brian

 

[synapsevampire]

Another means would be to use a cross-tab.

And here's another means for getting the first character:

Insert->Field Object->Right click Formula Fields and select New->Name the field and place something like:

left({table.invoice},1)

Now select Insert->Cross-tab

Place the formula field in the Rows, and the amount to sum in the summarized fields.

This will produce a summary report.

-k

 

[JCook23]

Thanks Brian!