how to sum all values in a column ?


I have this report but i am not figure out how to sum all values present in column "DoctorID" ? I just put variable $V{COLUMN_COUNT},it gives no of rows in a column

sagarnikam123's picture
Joined: Nov 1 2012 - 10:33pm
Last seen: 4 years 6 months ago
What type of field is DoctorID? Is it a string? Why would you want to sum them? What would a sum mean for you in regards to DoctorID?
lisacbeaton - 10 years 6 months ago
DoctorID is an integer,i want to sum them...forget about ID,its an misleading name,sum means adding all values of column "DoctorID" to get actual total instead of 9 in last row
sagarnikam123 - 10 years 6 months ago

1 Answer:

Yeah, unless they are number types you will only be presented with the option to count. If the fields are number type then when you drag the field over iReport will give you the option of sum in the drop down.

jvway's picture
Joined: Mar 9 2009 - 11:43am
Last seen: 7 years 2 months ago

Put sum not count! count = 9, sum = 49959

dieguito28 - 10 years 6 months ago