Forum Discussion
Need a filter based on transaction level
Need a filter based on the below sample data, transaction level Please help
tex628 I tried different formulas, but filter is not showing CR & DR, rest everything is showing.
Can you by any chance provide a picture of the outcome?
/ J
That is because on a transactional level there are no records that has both Credit and Debit.
Currently you have only credit transactions in "ONLY CR BAL" table, and you have only debit transactions in the "ONLY DR BAL" table.
In your "CR & DR" Table, do you want all transactions or what is your aim here?
/ Jtex628 first customer is having both debit and credit. In need that filter in this case.
tex628 ,first customer is having both debit and credit. In need that filter in this case.