hi,
the collumn i want to add is to summarize the total value from other collumns, its like :

col_1 col_2 col_3 col_total
2 2 2 6

its something like that, where col_1-3 is generated from mysql and the col_total is the collumn i want to add to that table.

thanks again,
Mo.

If you show data from a database, it is more simple way to calculate value of the column in SQL query. SQL query will look like:



Regards,
ARI Soft

did you mean i put that query after my first one?
and how i associate the query result to the column andor how to add the collumn

sorry for sucha noob question
thanks again,
Mo.

Could you provide your SQL query and specify what columns do you want to calculate?

Regards,
ARI Soft

hi admin,

sorry for late reply.

my sql query is


i'm hiding some unneeded field and the result is this table


on the image above, the red border is some collumn and row i need to add.
the "sub total" column will contain "x" value wich is the sum from column 1 to 7
the "%" column will contain "z" value wich is the percentage of "sub total" compared to "a" column
and on the last row i need to add total which "y" is the sum from all row above on that collumn.

thanks for your help
regards,
Mo.

Could you send SQL dump of hsnjz_chronoforms_data_peserta table with sample data by email because it is not clear what columns the table contains?

PS: The extension doesn't support ability to create total column (the last row in your sample).

Regards,
ARI Soft