Columns in a report are Date, credit, debit, account_no.It should display data such that, if same amount of credit and debit are made on same dates on a specific account, then such data should not be displayed.
1. Create a report with all the columns and an additional column which is debit-credit=0.
2. Create the main report, add a filter with criteria “is dependent on results of another analysis” and point it to report1 and condition type “is not equal to date in it”
3. This filters out the rows which have the same amount of credit and debit on the same day on the same account.
No comments:
Post a Comment