Add or sum the value of a column

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I made a summary table but want to have a column for the sum of the values because i will use it for another field (this field will have a formula for this column). I need to have to sum all the values, without using the summary table options (summarize the columns). its like having two total columns.



Please see attached.

Photo of Ann

Ann

  • 22 Points

Posted 4 years ago

  • 0
  • 1
I'm not understanding.  Can you give an example using the data in your posted screen shot?
Photo of Ann

Ann

  • 22 Points
for example

               col1        col2        col3      total(another field with the sum of the 3 cols)                 total(from the summary table)   
ALDI        1              4             7                                   12                                                                              12
Baltic       1               1            1                                     3                                                                                3
                                                                          **this above is what i want
If you make a new field in your details table with a formula of the sum of whatever is in columns a b and c, then you can include that as a field in your Summary Report.