total	no	yes
totals	129	106	23
R&R	46	39	7
nbd	53	38	15
same day	30	29	1

 

I want to report on 95% of these values.

I have the following formula to calculate 95% of the total

 

formula = Count ({ALL_.Actual Met Commitment})/100*95 but i only get an answer of 122.55 which is 95% of 129. How do i apply the same formula to the subtotals? I want 95% of each of the numbers above, not just the total count. I am trying to work this out as I am plotting this information in a chart and want an additional range of data at 95% of count, this is a target. if there is another way of plotting this fabricated data i would like to hear this too.

thanks

 

 

 

123 * .95 = 118.85

x :=({count} * .95}

 

If that is the correct answer that is the formula.

 

Regards

 

John W.