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_Related Related Topics sp_TopicIcon
use grouping to calculate percentages
16/11/2010
20:03
Avatar
patriiiiiiiiiick
New Member
Members
Forum Posts: 2
Member Since:
16/11/2010
sp_UserOfflineSmall Offline

Suppose I have three columns based on which I want to calculate percentages: todo, done, complete. Todo is a number of items to be done. Done is the part of the previous one which has been completed. Complete is true (=1) if the two previous data are equal.

Suppose I have those two rows:

Todo Done Complete
 5  3  0
 3  3  1

I would like to calculate the percentages of done (75% here) and the one of complete (50%). Can I do that in a group and / or in a summary footer?

TIA for your help!

Patrick

24/11/2010
20:28
Avatar
patriiiiiiiiiick
New Member
Members
Forum Posts: 2
Member Since:
16/11/2010
sp_UserOfflineSmall Offline

Obviously, what I would like to do is not possible this way since the summary footer and such functionality only apply to the currently displayed page even if the full grid has been loaded.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
35 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