Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sum() By Part of Field Value

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)

Former Member
Not what you were looking for? View more on this topic or Ask a question