SUM DISTINCT

[t16turbo]

hi there,

is there a way I can perform a sum of distinct values in an expression?

My sql behind the report returns one or more rows for a single time entry (as I am also returning timehseet notes)

My report has grouping levels with the timesheet notes at the lowest levels
I need to only sum the actuals at distinct time entries, rather than each time entry being multiplied by the number of notes that are against it.

 

[johnberchmans]

Yes, there is.

The expression should be of the form:
Sum( <DataRow Variable> ) Distinct( <DataRow Variable> )

I hope this helps.

-- JB