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 bottom
Post Reply
Post New Topic
Page: 1
TOPIC: sum values? [Solved]
#173
sum values? [Solved] 2 Years ago Karma: 0
It would make the sum of the values in the row?
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
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.
Reply Quote
 
#177
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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
viljem
Admin
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#178
Re:sum values? 2 Years ago Karma: 0
Thank you. This is form me ideal solution.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
connic
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: tomaz
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting