Comparing the delta between 2 columns

Adam_B

Hello, 

I have a data set with 2 columns, both were created by a formula earlier in my workflow.

I need to compare the 2 columns with what I will assume is a Summarize tool, and count how many deltas there are. 

So if the "Note" Column is populated, and the "Right_Note" column is not, I want to count that as a a delta.  In the example provided there would be 9 counted on the "Note" side and 3 blanks counted on the "Right_Note" side. 

Thank you!

Adam 

DataNath

Hey @Adam_B, when you say you're making the field in a Formula tool earlier in the workflow, are you by any chance doing something like this whereby you perhaps have an 'else' than results in ''?

As you can see in your first screenshot, the blank entries in your data are actually just empty and are not null. Hence why counting nulls won't work. If you want to use this approach then you could change your Formula to this where the 'else' is null(), which would allow the count null approach to work:

If you want to keep the Formula outcome as is, then you could perhaps add another statement that results in 1 when the field is empty and 0 if not, that you can perform a count on: