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
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.