Full Version: Percentage issue if then 0 vs low percentage.
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
natashaepperson
Sep 26 2005, 09:22 AM
=IIf(Nz([amtBidbyCSM]/[TotalReq],0) Or [TotalReq]=0 Or [amtBidbyCSM]=0,"0%",[amtBidbyCSM]/[TotalValue])
146,223/87,341= 1.67... with round up 2% But currently the above coding gives it a 0%
Most of the report % do fine. But if the Percentage is a low number it kicks out 0% when it should be a 1% or even a 2% with roundup.
strive4peace
Sep 26 2005, 01:19 PM
try this:

=IIf( nz([TotalReq])<> 0, IIF( nz([TotalValue])<>0, nz([amtBidbyCSM]) / [TotalValue] ,0) ,0)
natashaepperson
Sep 26 2005, 02:42 PM
got it frown.gif Thanks!
strive4peace
Sep 26 2005, 02:45 PM
you're welcome wink.gif happy to help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.