sum values? [Solved]

It would make the sum of the values in the row?

Hi,

sorry there is no one-click solution with TableJX.

But it is possible if you create view and display view in TableJX.

If you have data:
nome_item Sunday Monday Tuesday Wednesday Thursday Friday Total
item1 12 5 5 9 4 23 58
item2 2 6 2 2 45 3 60
item3 3 7 3 3 4 3 23
item4 4 8 4 4 4 5 29

In DB editor (e.g. phpMyAdmin):

CREATE VIEW Calculation AS
SELECT nome_item, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday,
cast(Sunday as int)+...+cast(Friday as int) as Total
FROM mytable

Regards,
Viljem

Thank you. This is form me ideal solution.