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
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
Hi Mahboob,
Thanks! the In([Size]) worked
Regards