Hello Community,
My dataset includes transaction IDs, multiple currencies (e.g. USD, GBP, EUR, etc.) and the value associated with each transaction in a specific currency like in the table below. I want to filter this dataset so the output shows all transactions as is if they are in any currency but EUR, and if the transactions are in EUR than I want to include only those that <= 1,000. Please advise what custom formula I can use for this.
| ID | Currency | Value |
| 001 | USD | 1,000 |
| 002 | EUR | 5,000 |
| 003 | EUR | 500 |
| 004 | CAD | 2,000 |
