Link to home
Start Free TrialLog in
Avatar of tuttiwala
tuttiwala

asked on

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.

ASKER CERTIFIED SOLUTION
Avatar of madheeswar
madheeswar
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tuttiwala
tuttiwala

ASKER

The question was never really answered to my satisfaction, but I do appreciate the help.
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