UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Percentage issue if then 0 vs low percentage.    
 
   
natashaepperson
post Sep 26 2005, 09:22 AM
Post #1

UtterAccess Guru
Posts: 686
From: Houston TX
=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.
Go to the top of the page
 
+
strive4peace
post Sep 26 2005, 01:19 PM
Post #2

UtterAccess VIP
Posts: 20,187
From: Colorado
try this:

=IIf( nz([TotalReq])<> 0, IIF( nz([TotalValue])<>0, nz([amtBidbyCSM]) / [TotalValue] ,0) ,0)
Go to the top of the page
 
+
natashaepperson
post Sep 26 2005, 02:42 PM
Post #3

UtterAccess Guru
Posts: 686
From: Houston TX
got it (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif) Thanks!
Go to the top of the page
 
+
strive4peace
post Sep 26 2005, 02:45 PM
Post #4

UtterAccess VIP
Posts: 20,187
From: Colorado
you're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) happy to help
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 03:20 AM