sum up different values

[dominicanlauf]

Hello everybody,

I have a table that should sum up the pieces produced. There is a product A and a product B, which differ by the property "cylinder = 0 or> 0".

I would like to look at the number of produced pieces  of both products separately.

My idea was: if (cylinder = 0, sum (productionstatistic.produced))

if (cylinder> 0, sum (productionstatistic.produced)

This does not work.

Does anyone know how to solve the problem?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Try: sum ({<cylinder={0}>}productionstatistic.produced)

Make sure to use the correct case sensitive field names.