I have some loan contracts which have some dedicated collateral and also every month a part of them will be paid and remain balance(should be paid in next months) are calculated and stored in another table.
The problem is : in collateral tab I want to show only collaterals which their remain balance is not zero
In attached file: when I filter 20180701 I expect to see just contract no 1 &2 (not 3,because its balance in this date is zero)
