Ignoring negative in the count.

[ManuelRodrigues]

Hi All 

I am trying to setup a frequency counter based on two parameters [Employee number/name] and [employee number/Location]. I have managed to do this however i would also like to ignore any negative values being counted e.g.

Current view

Proposed View

Thanks!

[gabrielvilella]

Maybe a formula, if that number is < 0 then fill with 0.

[atcodedog05]

Hi @ManuelRodrigues 

Can you provide some sample input and expected output in an excel file It will help us get a better understanding of the usecase.

We will be happy to help : )

[binuacs]

@ManuelRodrigues Another option similar to @gabrielvilella in the formula if the number is < 0 the Null else 1, then use the summarize tool and use the option Count Non-Null