Search code examples
reporting-servicesssrs-2008reportingservices-2005

Total of Custom Expression

I'm trying to get the total of the "Conversion" column for each "AccountDescName".

However, the expression inside is also grouped by the statdate.

enter image description here

How would I go about getting the total of the conversions.

enter image description here

When I paste that same expression in a row below, it gives me a different number.

Solution

  • I figured it out by keeping my data split up by rows and removing duplicates. Did not do any aggregation in SQL.