Calculate sum of a coloumn

[#1]

Hi all,

I have the expresion if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0) and i want to caluclate the sum of the counts produced by the expression.

Any help???

Thanks in advance.

[Gysbert_Wassenaar]

sum(if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0))

or if you're using a straight table set the total mode to sum of rows

[#3]

I tried setting the mode of sum rows in the table and i get the result. But how do i use this result to make other calculations????

[Gysbert_Wassenaar]

Then you'll have to use sum(total if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0))