I have an expression that is working in the expression builder but not in the app.
It is using data from two tables Product and PurchaseOrderDetails. I am try to make an action to change the value in a column to add the value in this expression:
Sum(select(PurchaseOrderDetails[Quantity], and([ProductID]=[_thisrow].[ProductID], or([Order Status] = “”, [Order Status] =“Submitted”, [Order Status] =“Ordered”))))
To a column [bought] but the action changes it to 0 , which is a different result from the expression builder.
If I put the expression in a virtual column then create the same action it works.
I was hoping someone could tell me why?