showing the sum of field values

hi
i have a question and i hope you can help me

if i have a field named "number of students in the class "
and each article has details about certain class

are there a method that show the sum of the number of students in all classes ?

in other words
if i have afield with these details

field name : number of students
field value : 10 "or any other number"

can i have a code that show the sum of all values written in all articles of this field ?

i hope that i explained it clearly
thanks

Hello

you can edit category_items.php (or category_items_html5.php) of your custom FLEXIcontent template

components/com_flexicontent/templates/MyCustomTemplate/category_items.php

and your custom code at the end of this file

thanks Mr. ggppdk for replying
i tried to put that code in the file
but it doesn't appear

can you please tell me the appropriate code
for displaying that sql in side category template ?

the goal of that sql is to
show the sum of field values in the category

thanks

Hello

this question maybe useful to others, so i have made a FAQ article:

Example of calculating an aggregated field value for the items assigned to a category

Hello

code highlighting needs to be setup in new flexicontent.org

[edit: i have corrected the code below, just set a correct field id]

please recopy code from the FAQ article and change the
$field_id to be the id of you field.

if you paste it inside PHP code, then remove the starting <?php and the trailing ?>

Regards

thanks Mr ggppdk for helping me
it is now working

but i have another question please
what if i wanted to show the sum of values of two or more fields ?

i should edit the

or what should i do ?

thanks again