Combining tool formula

maddoxs

Hello all. I have a question regarding two inputs that I have coming in. 

1 is a billable lines input (sales order lines that are ready to be invoiced) 

2 is all the sales order lines (sales order lines that are ready to be invoiced or not)

As shown below, only 6/10 billable lines are ready to be invoiced. Is there a way that I can use a tool to show once billable lines equals sales order lines - I can push this out to show its ready to be invoiced ?


Billable lines 

All sales order lines 

Thank you for any assistance!

DataNath

How does something like this look? I'm not sure if both datasets are much larger/have various different Sales Orders within them but I've built out an example assuming that, showing one where billable != total and another where it does to show the 2 outcomes. The workflow just performs a count of both, grouped by sales order, and if they aren't equal flags them as not ready for invoicing and vice versa if they are equal.

Check billable vs sales order lines.yxmd