Skip to Content
0
Sep 22, 2014 at 01:56 PM

Query does not monitor all rows for an approval procedure

115 Views

Hi Experts,

I'm trying to create a query for an approval procedure, which monitors the discount percent field in the rows (and catches the ones below zero). As far as I'm concerned, this works fine for a 1 row document:

IF (CAST(Replace($[$38.15],',','') as INT)) < 0

SELECT 'TRUE'

My problem is, if there are more than 1 rows in the document (and the first one is not a negative number), the approval window does not appear and the document gets Added.

Please, help me in converting this query to a one, which monitors all the rows.

Thank you!

Zoltán Karner