I have a dataset with many records and some numeric fields:
Pre-calculated variables: A, B, C, D
Calculated variables: E = A+C, F= D+B
I want to remove rows based on certain criteria. i.e
if C<10,000 AND B<20,000 AND if the new value of E (after removing the row) would be <10,000 AND if the new value of F (after removing the row) would be <20,000
A bit stumped on how to do this, can anyone offer any advice please?
Hi @monilpatel89 ,
I don't see "Running Total" in your description, but if you want to remove rows, Filter tool would be the first choice.
If I miss anything, please point it out.