hi guys,

so i have this template, an array of data, which shows my recorded invoices and payments. i also use pivot table to create a report for this.
so in the template, the invoices are shown at a positive value, while payments are in negative so as in my pivot table, it will show the sum of invoice less the payment.For example:
invoice # 5678 - - - - 45,967.98
payment OR 263- - - - 45,967.98
the total should be shown as "0" or in Accounting Format as "-".

But some of the results show "0.00", "(0.00)", which when you see in formula bar it is equivalent to something like "2.3565465e16" which means the result did not come up to absolute zero as expected. it still has remaining decimal digits. the problem is i use a formula that will tell my pivot to show all the invoices which are already "completely paid" and hide those with still remaining balance. so as in this case, invoices with this balance who are not in its absolute zero value will still be shown.ive been facing this problem for almost a year now but i cant still have anyway to solve it. any help will be highly appreciated. thanks a lot.!!!

IMPORTANT: I ALSO USED "ROUND" FUNCTION FOR THIS BUT STILL DID NOT HELPED ME THE WAY I WANT IT TO.