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...
MFelix
Super User
Super UserHi Anonymous,
Don't know if you want one formula with the comparision or not but try something like this:
Valid = SUM(Table[LineSum]) - MAX([money from recon test])
Then just add this with the Expense ID to a table visual and you should get 0 if it equal.
Regards,
MFelix