GopinathSridara

Re: How to ignore the sum values where any of the Tag Value  > 10000 in the query

Discussion created by GopinathSridara on Oct 7, 2016
Latest reply on Oct 7, 2016 by kduffy
Branched from an earlier discussion

Hi Kelsey,

How to use attribute 'SPAN' instead of 10000 in the below query?

WHERE expr = '(if ((''PS14868_Tag1'' >= 2*(SPAN)) OR (BadVal(''PS14868_Tag1''))) then 0 else ''PS14868_Tag1'')

I want something like above, does it work like this?

getting syntax error -

Outcomes