Skip to Content
author's profile photo Former Member
Former Member

#ERROR WITH DIVISION IN WEBI XIR2

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 02:28 PM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.