Ignoring negative in the count.

Question

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!

binu_acs · Answer

@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

atcodedog05 · Answer

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 : )

gabrielvilella · Answer

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