Hi All,
I have a currency column with number values as below and I want to exclude only positive Zero entries, output also mention in below, can someone please help me with
Input
| 100.00 | |
| 150.00 | |
| 200.00 | |
| 600.00 | |
| 700.00 | |
| 0.00 | Positive Zero value |
| 0.00 | Positive Zero value |
| 0.00 | Positive Zero value |
| $0.00 | Negative zero value |
| $0.00 | Negative zero value |
| $0.00 | Negative zero value |
| (700.00) | |
| (600.00) | |
| (200.00) | |
| (155.00) | |
| (100.00) | |
Output
| 100.00 | |
| 150.00 | |
| 200.00 | |
| 600.00 | |
| 700.00 | |
| $0.00 | Negative zero value |
| $0.00 | Negative zero value |
| $0.00 | Negative zero value |
| (700.00) | |
| (600.00) | |
| (200.00) | |
| (155.00) | |
| (100.00) | |
