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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
> 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
ASKER