CrossTab Changing Numbers

[Rustin788]

Hey,



I am having an issue where a crosstab is changing the values in a column. Below is what the information looks like that the Crosstab is pulling from (Numbers made up aside from % proprietary). The % Proprietary column is the formula [Prop Sales]/[All Sales]. When I make the information a cross tab using the Customer=Row, and Year=Column, and % Proprietary=Values; the numbers change to just 1%, 2%, and 3%. I have tried everything I can think of but I can't seem to get the correct numbers to show. Oddly, it isn't even rounding correctly since the 2.76 goes to 2% and not 3%.

Any help would be appreciated

Year	Customer	Prop Cases	Prop Sales	All Cases	All Sales	% Proprietary
2012	Bob	100	3500	600	9053	1.47%
2013	Bob	200	5322	977	10986	2.76%
2014	Bob	300	5677	1754	13211	3.01%

Update: I was able to get it to show the correct information by using the IIF statement: IIf([% Proprietary]Is Null,0,[% Proprietary]) on the crosstab. I don't know why it worked but it displays the correct numbers.

[June7]

Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention. Better would be Pct_Proprietary.