Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Using Column Totals in other columns' formulas

Posted on 2004-11-23
Medium Priority
509 Views
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.

0
Question by:tuttiwala

LVL 19

Accepted Solution

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

is this what you are looking at?

Column to column talking is not possible in NOtes
0

LVL 15

Assisted Solution

Bozzie4 earned 132 total points
ID: 12662612
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

LVL 31

Assisted Solution

qwaletee earned 132 total points
ID: 12669780
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

Author Comment

ID: 12999109
The question was never really answered to my satisfaction, but I do appreciate the help.
0

LVL 31

Expert Comment

ID: 13019788
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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question