I am working with a transaction group and have everything working perfectly fine, except, if a step in the machines process fails, it logs a 0 to the server. This isn't a total problem, it just makes what we are using the data for a little harder. I started to look into it and found the expression item in the transaction groups and tried out this expression:
but I am only returning an error.
My goal is to return a NULL if the results are 0, otherwise return the results.
Is there something I am doing wrong within the transaction group?
Is there a better way to approach this?