Forum Discussion
comparing 2 total
i got a table look as in attached file for the same "ExpenseInvoiceID" i need the compare the Sum of "Linesum" with one of the line from"money from recon test" in this case 125.76+150= 2...
it looks like to be working
I got the same issue the sum if line sum 15049.79 - sum amount 172472.82 should be equal to diffe nav-xsp calculated with the formula u posted above,
strange things that between the line I can see just few cents different where result sho as 2280.18
i filter out the diffe that is not 0 put some of them still showing...
Hi Anonymous,
Could you please share a sample file and post your desired result to help me test your problem?
Regards,
Daniel He