Hello,
This is my first post on here; so far I’ve been able to work through any obstacles I’ve come across based on reading previous posts, but I’ve finally gotten stumped on something where I can’t find a previous post with the same context as what I’m trying to do. In a nutshell, my app does the following:
I’ve created a VC in my order line items table for the current sum of completed child records. As the status for the child records changes to “completed”, this VC field updates to show the current completed quantity. For example, there is a parent order line item record for 100 parts & 5 child records, each for a pallet of 20 parts (in 5 separate workstations). As the child records’ status changes to “complete”, the VC field updates, eventually to 100 when all child records are in a complete state.
The problem I’m having with my expression is getting the the appropriate “IF” criteria to work for the child records. Right now, I’m successfully summing all child records regardless of the child records’ status field, but whenever I try adding the “status” qualifier, I get some sort of error. Here’s my latest attempt that’s not working:
I feel like I’ve gotten too far into the weeds in trying to figure this one out so a fresh perspective would be helpful.
Thanks!
Solved! Go to Solution.
Just to clarify, 2x2 Rail Inspections is the child record table.
Face palm. Thank you Marc, I figured it was right in front of me.
User | Count |
---|---|
41 | |
28 | |
24 | |
24 | |
13 |