Skip to Content
0

How to calculate a percentage but ignore the factor?

Jul 11, 2017 at 04:13 PM

35

avatar image
Former Member

Hello All,

I have a webi report need to calculate a percentage for different factor levels. It looks like below

Size, Color, Sales

a, x, 10

a, y, 20

b, x, 30

b, y, 40

So I want to do the calculation and have the result like this

Size, Color, Sales, Size%, Color%

a, x, 10, 0.3, 0.4

a, y, 20, 0.3, 0.6

b, x, 30, 0.7, 0.4

b, y, 40, 0.7, 0.6

But when I tried to write the formula, it always give me a result like:

Size, Color, Sales, Size%, Color%

a, x, 10, 0.1, 0.1

a, y, 20, 0.2, 0.2

b, x, 30, 0.3, 0.3

b, y, 40, 0.4, 0.4

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mahboob Mohammed Jul 12, 2017 at 12:45 PM
0

Hi Shiruo,

Do you want to get the percent by Size? To the formula you're using, add =existing formula Foreach ([Size]), if that doesn't work, try In ([Size]).

Thanks,
Mahboob Mohammed

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mahboob,

Thanks! the In([Size]) worked

Regards

0