Filter Orders > 100 EUR

[andreip21]

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

[tresesco · Accepted solution]

Try a search string (in the trigger) like:

= '('& Concat(Distinct {<OrderID={"=Sum(UP * DMS_Quantity)>100"}>} OrderID , '|') &')'

[ajaysingh285]

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.

[andreip21]

is working. thanks a lot. i have a magical button right now