Remove rows in data set based on values within fields as well as running totals

monilpatel89

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?

Yoshiro_Fujimori

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.

Filter.yxmd