Welcome, Guest
Please Login or Register.    Lost Password?

sum values? [Solved]
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 1
TOPIC: sum values? [Solved]
#173
sum values? [Solved] 6 Months, 1 Week ago Karma: 0
It would make the sum of the values in the row?
connic
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/07 04:24 By viljem.
The administrator has disabled public write access.
 
#177
Re:sum values? 6 Months, 1 Week 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
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#178
Re:sum values? 6 Months, 1 Week ago Karma: 0
Thank you. This is form me ideal solution.
connic
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting