sum values? [Solved]
(1 viewing) (1) Guest
|
TOPIC: sum values? [Solved]
|
|
sum values? [Solved] 2 Years ago
|
Karma: 0
|
|
It would make the sum of the values in the row?
|
|
|
|
Last Edit: 2010/02/07 04:24 By viljem.
|
|
|
Re:sum values? 2 Years ago
|
Karma: 1
|
|
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
|
|
|
|
|
|
|
Re:sum values? 2 Years ago
|
Karma: 0
|
|
Thank you. This is form me ideal solution.
|
|
|
|
|
|
|
 | | | |
Tools JX, Powered by ; by SG