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:

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

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

You already have an active moderator alert for this content.

Hi Mahboob,

Thanks! the In([Size]) worked

Regards

## Add comment