Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Grouping custom summarytype function + get total summary
28/10/2014
09:39
Avatar
songcon2
New Member
Members
Forum Posts: 2
Member Since:
28/10/2014
sp_UserOfflineSmall Offline

Name      |     Budget       | Used        | %Budget
-------------  -------------------   -------------   ------------------
GROUP A
               | 6                   | 3              |
               | 2                   | 1              |
               | 6                   | 5              |
                  14                    9                    = 9/14 * 100 => ????
-------------  -------------------   -------------   ------------------
GROUP B
               | 2                   | 1               |
               | 2                   | 1               |
               | 0.5                | 0.5            |
                 4.5                   2.5               = 2.5/4.5 * 100 => ????
-------------  -------------------   -------------   ------------------

Currently I use jqGrid with Grouping and summaryType function in each Group

jqGrid support very good to sum value in the same column.

But in this case, i want to fill value to the

Total %Budget = Total Used (each group)/ Total Budget (each group) * 100

Example in first Group A:

In custom summarytype function of %Budget cell. I want to get values

- Total Budget = 14
- Total Used = 9

How I can get these values in jqGrid symmaryType?

30/10/2014
14:28
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

 

You may get idea from this post here

 

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
38 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information