Percentage calculations.

[Guest]

I am trying to create a percentage of information received by color. The
following works great, but now my percentage has doubled itself.

=IIf([OTHER COLOR]=0,0,("[OTHER COLOR]","[Calc qry]")/[TOTAL COLORS])

If I have "2" in the data field, I receive 200.00% instead of 100% OR 5
white carpets and 1 red carpet, I get 500% on the white carpeting and 100% of
the red carpeting of the [TOTAL CARPETS] coloring on hand when It should be
100% of the total. If I have 1 carpet color and no other entries, I do
indeed receive 100% of the total carpets.

What am I missing? I've stared at this for so long, I couldn't see the
error if I fell over it.

Thanks in advance.

 

[Guest]

yeeee HAAAWWWW!!! I figured it out. I actually did trip over it. Thanks
anyway guys.

 

[Guest]

Oops, forgot to show what happened:

=IIf([WHITE CARPET]=0,0,[WHITE CARPET]/[TOTAL MALES])

I got rid of the Calc qry from the statement, works perfect now!!