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.
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.