A
accesshelp
Maybe I am just low on brain cells.... but I have a question.
I have a report in which I have 4 categories. I am trying to find out what
the percentage of the total for each category. Let's say I have 1 in
category 1. I want to divide 1/3 to get 33%. For some reason my report keeps
telling me 3. I tried changing the format to a percentage and I get 300%.
This is driving me nuts. What am I doing wrong?
Also, if I want an N/A wherever there is a zero, then what do I have to do?
Right now those fields say #Div/0!.
Thanks a million.
I have a report in which I have 4 categories. I am trying to find out what
the percentage of the total for each category. Let's say I have 1 in
category 1. I want to divide 1/3 to get 33%. For some reason my report keeps
telling me 3. I tried changing the format to a percentage and I get 300%.
This is driving me nuts. What am I doing wrong?
Also, if I want an N/A wherever there is a zero, then what do I have to do?
Right now those fields say #Div/0!.
Thanks a million.