Help with Referenced Rows expression on action

[Quality_Assuran]

Hi community 

I need help with an expression I have on an execute an action on a set of rows. 

The action I am running on the Related Recipe is a delete this row action.

I want to delete related rows where the quantity is blank or zero. When I run this action it deletes the whole recipe, even the records that are not blank or zero. What is wrong with my referenced rows expression?

select(
[Related Menu_Recipes][Recipe_ID],
or(isblank([Related Menu_Recipes][Recipe_Qty]),
  IN(0, [Related Menu_Recipes][Recipe_Qty])
)
)

[Suvrutt_Gurjar · Accepted solution]

Please try 

SELECT(
[Related Menu_Recipes][Recipe_ID],
OR(ISBLANK([Recipe_Qty]),
[Recipe_Qty]=0
)
)