Skip to Content
avatar image
Former Member

How to calculate a percentage but ignore the factor?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 12, 2017 at 12:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded