Announcement

Collapse
No announcement yet.

Count value each column

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

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

    Comment


    • #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


      • #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


        • #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...
          X