Hi,
when using conditions on a query, it seems that the result row for the query is being calculated BEFORE the condition is applied? Can anyone validate this?
the issue is that while some records are being dropped by the condition, a result row is still displaying for records which did not meet the condition criteria.
any help is greatly appreciated. Thanks!