sum up different values

dominicanlauf — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: sum up different values

Gysbert_Wassenaar — Mon, 20 May 2019 07:16:28 GMT

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

Make sure to use the correct case sensitive field names.