I am relatively new to using IDEA for analysis, and I've been trying to figure out this testing, but I'm not sure if I'm just missing an obvious solution, or maybe there's another way to do this testing.
I am analyzing travel expenses and I want to identify and extract entries where every other field is the same (i.e. report key, expense type, travel start date, travel end date, transaction date, etc.) EXCEPT for the expense amount fields.
Basically, I'd like to identify and extract records where the two following scenarios occur:
1. Entries where the expense amount column has a positive and negative amount of the same value (i.e. 500 and -$500) and
2. Entries where the expense amount column totals $0. And by this I mean that I noticed that some transactions might have more than 1 entry to back out an existing expense. (i.e. 1000 and -800 and -200).
If #2 isn't possible, that's ok, but at least #1 would help us reduce the number of transactions that we might end up investigating only to find that they were backed out.
Once I identify these back out transactions, I can then filter them out of the original dataset so we don't pick up those transactions for testing.
I hope that's clear, but any help or advice would be appreciated.
Last seen: 3 weeks 6 days ago
Joined: 07/13/2021 - 15:04