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.

dummy_cero.xlsx

DataNath

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.