Sum of Distinct values

Hi Team,

I am working on pulling sum of values from a particular table column in Celonis using PQL. I want the sum of distinct values of the table column. However, when I do SUM(DISTINCT Table.Column) it is giving me sum of all the values in the column and not the unique ones.

Is there any way in which I can find the sum of unique values of a table column?

Thanks in advance

Soham Potdar

Hi Soham,

have you tried using the following statement?

SUM (COUNT ( DISTINCT table.column ))

this formula should first count the distinct values of a column and then sum all of them without considering the duplicates.

Carlo Alberto