Count value each column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sab0tajue
    Senior Member
    • Jul 2019
    • 315

    Count value each column

    it is required to count (amount of the filled in values) each column in the table how it can be made?
  • victor
    Active Community Member
    • Aug 2022
    • 727

    #2
    Are you talking about this? Columns whose values ​​can be summed?
    Attached Files

    Comment

    • Sab0tajue
      Senior Member
      • Jul 2019
      • 315

      #3
      not really. I have numbers in the "cadastrnum" column (row field type), some cells have no numbers. I just need to calculate in the end how many filled values there are in the "cadastrnum" column. Then I will scatter this logic on other pillars

      Comment

      • victor
        Active Community Member
        • Aug 2022
        • 727

        #4
        What field type does cadastrnum have? Most likely you are trying to sum non-numeric fields (which simply cannot be summed).

        I just need to calculate in the end how many filled values there are in the "cadastrnum" column.
        Then create a filter Not Empty for this field, and simply add Count to the report (as shown in the screenshots).

        Attached Files

        Comment

        • Sab0tajue
          Senior Member
          • Jul 2019
          • 315

          #5
          and how to display everywhere only the total without displaying the values? I need in column "A" the sum of the values in the column, in column "B" the number of values in the column

          Comment

          Working...