I have two datasets, Invoices and Purchase Orders and I am trying to compare the subtotal amounts for them to make sure they are the same. Invoices has the names of all the employees who worked on it and all those employees are applied the same Purchase Order. So I use the subtotal function to sumup the PO.
The other dataset has the lump sum amount of the POs.
The problem is that the subtotals in the invoices dataset do not line up with the POs because the invoices has more rows (because it has the list of employees that worked on that).
Is there any macro or conditional formating rule that can be applied to overcome this problem?