Is there a way to change my data or Aggregate function to NOT count blank cells?

1

Is there a way to change my data or Aggregate function to NOT count blank cells?

I have a table with a column of data that I did an aggregate function on. my goal was to count how many cells within the column have a value. However, the aggregate function is counting blank cells as well as filled values. How can this be modified so that it only counts cells with a value?

2

The "Count" aggregation mode in the "Aggregate" action doesn't count empty values.

Most probably, what you believe is blank cells aren't actually blank - they contain whitespace or empty text - text values with zero length. You can make them actually blank (empty) before aggregation using, for instance, the "Clean up" action:

image
image515×468 47.5 KB

1 Like
Support for comparing <empty> null values to empty string for table comparison