I have a simple report that has a count of the number of answers for a question. I have created a variable that has the sum of the counts for that question. I would like to create another variable which will give me the percentage of each answer and then add that variable to the report.
I know that I can highlight the CharCount field in the report and then choose the Percentage under the INSERT SUM button in the toolbar but this doesn't give me what I want in the end. I want to be able to filter by the Characteristic field and keep only the "Always" characteristic, but when I do that using the Percentage from the INSERT SUM button it changes the percentage to 100% which is what it should do in that context. I want to create a variable that will hold the original 88.56%. What we are trying to do is rank the "Always" characteristic.
What I am trying to get is a rank of the customers grouped by this question and other questions with the same characteristics by the highest percentage of "Always". I thought the best thing to do was to create a variable [CharSum] which would be the sum of the [CharCount] field. Then create another variable [Sum%] with the following code:
=([CharCount]/[CharSum])
but when I add that variable to the report I get an answer of 1 in each cell for each characteristic. Somehow my CharSum variable is holding the CharCount for each individual charateristic instead of staying at a sum of say 848.
I have only been using WEBI for about three weeks now so excuse me if this is a very simple answer. I am taking the WEBI class in late July.
Thanks in advance!!