Hi Jia,

there is no such function SUM(DISTINCT) as in SQL , but you can probably achieve your result by using a DOMAIN TABLE

Assuming you want only unique values for a certain column (i.e. unique values for a certain plant)

the formula should look like

PU_SUM(DOMAIN_TABLE(table.PLANTcolumn),Table.Amount)

Best,

Gabe

This seems like you are getting duplicate values? Maybe a solution would be to deduplicate the data beforehand and then using the regular SUM() functionality. You could also do this within the Event Collection of Celonis, if you are interested in doing this let me know an we can provide a script for you.

Best,

Kevin