on 11-23-2007 11:59 PM
Post Author: David-Abiodun Oloruntoye
CA Forum: WebIntelligence Reporting
I have a calculation like this:
DIM1
COL 1
COL2%
A
1
1/55
B
2
2/55
C
3
3/55
D
4
4/55
E
5
5/55
F
6
6/55
G
7
7/55
H
8
8/55
I
9
9/55
J
10
10/55
Total
55
My challenge is that when I create such a variable in WEBI, it is returning #ERROR for all the rows in the columns.
Pls, what do I do.
Cheers.
Oloruntoye
Post Author: jsanzone
CA Forum: WebIntelligence Reporting
There is a very useful feature in WebI that performs exactly what you are trying to do, but with only three clicks required.
Once your report output is obtained and you are in the "Edit Report" mode, highlight the column of numbers (Col 1) in your case (remember, highlight the data and not the column title). Next click on the drop down menu selector for the "sum" function on your toolbar (the sigma symbol). Lastly, click on the option "Percentage" and voila you have your percentage of each of the dimensions based on the total of the column. In my humble opion, I believe that "Percentage" is mislabeled and should be called "Percentage of" because that is exactly what the option is performing, a percentage of the total for the selected column. If you are familiar of doing this operation in Excel, you do something like: (in cell C1 you would type: =b1/$b$11 in cell C2 you would type: =b2/$b$11, etc, etc. I think the three button click for Percentage is much easier to work with, hopefully this will work for you as well.
God Bless!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.