Count Values 1's

[neromerob]

Hello.

I´m here because I need to do a count, the values are 0 and 1, and you gest it, I need the 1´s

But the problem that I face is that the summary tool only considers count distinct from null.

So not quite sure to do here, transform the 0 into null? Another tool?

Thank you.

[IraWatt]

Hey @neromerob,

you can get a count of the 1/0's by grouping by that fields values and counting them:

[DataNath · Accepted solution]

As you're just using 0 and 1, you can just do a sum and this will act the same as a count of your 1s:

Obviously if you want a count for the whole table, you can just sum these 2 fields with a formula tool.