I have a crystal report that displays data from a datatable. I need to be able to summarise on of the columns by adding all the values for the particular group. When I add the sum operation it gives me the count instead of the group sum. From what I have read this could be due to crystal reports converting everything to string. How do I fix this?

I have two formulas as follows:

Wow I am in way over my head with this. I must find a way to get it done however. First do you have any idea why the sum operation is displaying the count instead. And, secondly what approach would you recomend for a novice like myself. Are there any online tutorials that you would recomend.

I am still getting counts and not sums. I want to have the sum of ml for each individual group. Both running total and sum give me the row counts.

Edited by jbillens - 12 Mar 2012 at 5:00am

Ok I was doing everything write in crystal reports. I did not have the datatable column set up to be an int32. After doing this all works as intended. Thank you DBlank for you patience and help.