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) |
@suneetha Use the filter tool
Is the positive zero values indicated by having no "$" in front of it? If so, you can use a filter with the formula:
[Currency Field]!='0.00'
This filter excluding both Positive and negative zero values
@suneetha In your data in the input file, how is the negative zero represented? Are they prefixed with $?
Hi
it has "$" in front of zeros
@binuacs
yes it has "$" in front of zeros
@suneetha The workflow which I provided is working for you?
Below is the input file i used
and the output is