This content has been marked as final.
Show 3 replies

Re: Background color expression in pivot table
Gysbert Wassenaar Sep 2, 2016 2:23 AM (in response to Nishanthi Rajendran)No, A/(A+B) will always be smaller than 100 if A and B are larger than or equal to zero as long as not both A and B are zero. In fact it will always be smaller or equal to 1.

Re: Background color expression in pivot table
Nishanthi Rajendran Sep 2, 2016 2:59 AM (in response to Gysbert Wassenaar )But I am getting a proper count in the pivot table

Re: Background color expression in pivot table
Gysbert Wassenaar Sep 2, 2016 3:13 AM (in response to Nishanthi Rajendran)That doesn't change the mathematics. The result of a number larger or equal to zero divided by the sum of itself and another number larger or equal to zero can never be larger than one (as long as not both are zero which results in infinity), never mind 100. So the test in your if statement will always return true and your if statement will never execute the second branch.

