Sum Column based on value change in other column

[Herbert]

Hi all,

I have a Report where I want to sum Column1 when the value in Column2 changes.
How can this be done in Stimulsoft Reports?

Best Regrads
Herbert

[HighAley]

Hello, Herbert.

You could use the SumDistinct() function for this.

decimal SumDistinct (object dataSource, object conditionExpression, object sumExpression)

A function returns the sum of all unique values in the specified column or expression.

Parameters
dataSource - The Data Source for processing.
conditionExpression - A condition expression to perform summing on.
sumExpression - An expression to sum up.

Return Value
A decimal number.

Please, look at the attached sample.

Thank you.