Skip to main content


 

Sometimes when you have a list view, you would like to aggregate entire colums by either adding, counting, and finding the average, minimum, or maximum of the columns.  

 

 

 

In the properties window, you will see a section called Aggregation. 

 

 

 

16585iA7AFC98F04DEAC71.png

 

 

 

From there, select whichever aggregation you would like and then it will appear in your list view.

 

 

 

 

 

17021i7ECC2B9A2D60559F.png

 

 

 

 



 

My list view contains 6 rows and 7 columns. I added aggregation (Count) on column. In expressions is written List count (name of column).

 

My problem is that Count counts all shown rows and not only this one which are not blank. I tried with modifying the expression with Non blank and If statement but no luck. Count result is 6 or 0.

 

 


Reply