Here is the basic requirement
I want the COUNT in a formula to only do a COUNT when the Bundle Status = “Ready To Ship”
COUNT(SELECT (Order Bundle Detail**[Bundle Status]**, [Job ID] = [_THISROW].[Job ID]))
What I want to achieve is to set the PARENT Record Status to “Ready To Ship” if ALL the CHILDREN Record Statuses are equal to “Ready To Ship”
So I have already got the COUNT of how many CHILDREN Records exist in another VC. All I want to do now is to do the same COUNT of these CHILDREN Records where Status is equal to “Ready To Ship”. If the COUNT of Number of CHILDREN Records = COUNT of the Number of CHILDREN Records where the Status is “Ready To Ship”, then I know that I can set the PARENT Record Status also to “Ready To Ship”
How would I write a formula for this?