Calculation based on Status of All related Records

[AgentsSka]

I have an Invoice System in which I'd like to define a calculation that analyzes all of the invoice's line items for a status of print ready or ship ready, and set's the order's global status accordingly.

 

In other words, if ALL of the line items status are either "print ready" or "ship ready", set the Invice status to "Good."

 

 

I can handle that calculation if it was always based on one line item, but I don't know how to handle all of the line items.

 

Please help.

 

[Raybaudi]

You'll get ALL of the line items with the List ( ) function.

So I think that you could use something like:

ValueCount ( FilterValues ( List ( LineItems::Status ) ; "Print Ready¶Ship Ready" ) ) = ValueCount ( List ( LineItems::Status ) )

 

[AgentsSka]

You'll get ALL of the line items with the List ( ) function.

Right.  But, then how do I set a calculation that analyzes the list?

[Raybaudi]

See my previous ( modified ) post

[AgentsSka]

Brilliant!!! 

 

Thank you!