I'm creating a Vendor Bill approval workflow where I need a condition (saved search condition) that needs aggregating the total Vendor Bill amount if the PO has multiple Vendor Bills. For example, a PO for 100 has 2 Vendor Bills. One for 40 and another for 70. The first bill is approved automatically because it is lower than the PO amount. However, the second bill must be added to the existing bills from the same PO. So, 40 + 70 is 110 which exceeds the PO. This should be routed for approval. I tried creating a saved search condition but I wasn't able to make it work.

Could you do it based on the PO amount?

Sorry, what do you mean by that?

Like in your Bill Approval WF can you validate the amount of the PO related to the Bill instead of the Bill amount in your decision Like in your example if the bill is $40 but the PO is $100 use the $100 from the PO which would push it over the approval limit

I think no. Because for the second bill, how can I total the amount of 2 bills before I compare it to the PO amount?