how to sum all values in a column ?

Posted on November 23, 2012 at 6:46am

 

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

iReport Designer
sagarnikam123's picture
sagarnikam123
48
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
add comment

1 Answer:

Posted on November 26, 2012 at 12:02pm

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
jvway
574
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
add comment
Feedback
randomness