I am having the requirement like if any of the row in sales order having above 50% discount then approval should triggered. I tried the following query but its returning only first row only. If any came across with solution? Please suggest solution.
SELECT MAX($[$38.15.0]) FROM DUMMY
Thanks & Regards