Using Crystal XI (with all the patches)
In my table/view I have a field called "Bill_Item" which has values such as "AAA111", "AAA477", "BAA985", "BBC287" etc.
I know I can sum based on the field like this:
Sum({Table1.Amount}, {Table1.Bill_Item})
But what I really need is more like this:
Sum({Table1.Amount}, Left({Table1.Bill_Item}, 3))
Is there a way of doing this? (other than the way I wrote it above which throws an error)