Using Column Totals in other columns' formulas

I have the following view:

Contributions (View name)
 -Contributor Name (col 1)
 -Number of Contributions (col 2)
 -Percentage of Total Contribution (col 3)

Example Data may look like this:

Contributions:
Fred Lord, 10, ?
John Guy, 90, ?

How do I calculate the 3rd column such that it shows the respective percentage of contributions? (i.e. For Fred = 10% and for John = 90%)

I know how to use column totals (which shows the total number of contributions), but I don't know how to programatticaly get at that value in the column formula for "Percentage of Total Contribution". Any ideas?

I'm not sure which is the best way to go about getting at the percentage?

Any help would be appreciated. Thanks.

tuttiwalaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

madheeswarCommented:
in the 3rd column,
@text(YourNumberContributionFieldname)+"%"

is this what you are looking at?

Column to column talking is not possible in NOtes
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bozzie4IT ArchitectCommented:
Well, column to column talking is possible in Notes, but not for totals.
(try it : name your first column "column1", put this as value in the second column, et voila)

You could have percentages in your categories - so start with a new column (type of contribution ?) then sort by Contributor name, categorized, then put in the totals column, use 'Percentage', and you would get the percentage of contributions per user.

But maybe a better way to do this, is create a Report document, where you would calculate everything (scheduled agent).  Then just sort the report document in a special view.  I can give you an example agent, I think.

cheers,

Tom
0
qwaleteeCommented:
There are built-in options for view column totals called "Percent of parent category" or "Percent of all documents."  It only work for categories, but you can still make use of it -- just make you first column categorized, your second column totalled (regular totals), and your third column totals using one of teh percent options. Mark each column to hide detail valuesNow your view looks like this:

CATEGORY Fred Lord      10      5%
DOCUMENT      <blank>
CATEGORY John Guy       190      95%
DOCUMENT      <blank>
BOTTOM                  100     100%

The bottom line is because Notes will total the overall view as well as each category.

The reason for the blank lines is that each category represents a "group" of documents.  In this case, each group is a single document.  But the category also has all the "indvidual" documentsin the group displayed beneath it.  Of the three columns for teh document, the first is the category, so it only shows at the category level, and the otehr two are set to hide detail values.

Yes, that's ugly, but all you have to do is collapse the view and it looks perfect!
0
tuttiwalaAuthor Commented:
The question was never really answered to my satisfaction, but I do appreciate the help.
0
qwaleteeCommented:
tuttiwala,

> The question was never really answered to my satisfaction, but I do appreciate the help.
The answer was "that's not posible, here are some things you might try as workarounds."  I guess you won't be satisifed unless we change Lotus's product for you?

- qwaletee
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.