### Title

Filter > 0 Problem in 12

### Post

Just ran into a portal filter problem with 12. I set the filter for Balance Due > 0 and it did not filter out the balance due <= 0 lines. I had to change the calc for Balance Due.

Old Calc: Balance due = Amount - Paid (sum(payments::amountpaid)

New Calc: Balance due = Round ( Amount - Paid (sum(payments::amountpaid) ; 2 )

Since now division or multiplication is involved and all of the numbers are two digit decimals, the round should not be needed, right?

Well, this smells like that old problem from 15+ years ago where in the 16th or so decimal places random digits appeared until someone fixed this. Quite noticeable in a spreadsheet.

4 / 2 = 2.00000000000000023543

Of course this could be something else...

Anyway, I suggest re-considering your filters and calculations in such instances.

Was it Richard Pryor who stared in the movie as the programmer who uncovered this problem in his bank employers program and became quite rich?

Amount -

Paid (sum(payments::amountpaid) ????That can't be right.

Did you mean:

Amount - sum(payments::amountpaid) ?

Have you checked the actual value--either in a data viewer, show custom dialog or a calculation field where you click into the field to see the unformatted value to check and see if this is in fact the case?

Be useful info to include in a bug report if it is.