how to Exclude only positive zero values

[suneetha]

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)

[binu_acs]

@suneetha Use the filter tool

[FinnCharlton]

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'

[suneetha]

This filter excluding both Positive and negative zero values

[binu_acs]

@suneetha In your data in the input file, how is the negative zero represented? Are they prefixed with $?

[suneetha]

Hi  

it has "$" in front of zeros

[suneetha]

@binuacs

yes it has "$" in front of zeros

[binu_acs]

@suneetha The workflow which I provided is working for you? 

Below is the input file i used 

and the output is