Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys.
Is there a solution to select all orders with total value above a certain threshold (let's say 100 EUR)?
I don't want to put it in the load script, i was thinking to a button object.
Bear in mind that i use the following expression for order value Sum(UP * DMS_Quantity). There's no calculation in the load script.
thanks,
Andrei
Try a search string (in the trigger) like:
= '('& Concat(Distinct {<OrderID={"=Sum(UP * DMS_Quantity)>100"}>} OrderID , '|') &')'
Try a search string (in the trigger) like:
= '('& Concat(Distinct {<OrderID={"=Sum(UP * DMS_Quantity)>100"}>} OrderID , '|') &')'
By creating a action on the button and pass the values you want to pass in the fields of button to get the desired result.
is working. thanks a lot. i have a magical button right now