Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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????
Then you'll have to use sum(total if([SensorValue]>High or [SensorValue]<Low,count(SensorValue),0))