I am using this field for a query:
Win Percentage: (IIf([ContractorNumbers] Is Null,0,[ContractorNumbers]))/(IIf([ContractorNumbers] Is Null,0,[ContractorNumbers])+IIf([BidderNumbers] Is Null,0,[BidderNumbers]))*100
Where [ContractorNumbers], [BidderNumbers] are both fields from other subqueries.
This works fine when [BidderNumbers] OR [ContractorNumbers] is 0, outputting 0 or 100% in either case, however if both [BidderNumbers] AND [ContractorNumbers] are 0, I get 0/0 and the query outputs #Num!
How can I change the field code to fix this?
OR, is there something else that I could do to fix the Bidder and Contractor queries that would avoid the 0/0 problem? Happy to link my database if that is the case.
THANKS!
Win Percentage: (IIf([ContractorNumbers] Is Null,0,[ContractorNumbers]))/(IIf([ContractorNumbers] Is Null,0,[ContractorNumbers])+IIf([BidderNumbers] Is Null,0,[BidderNumbers]))*100
Where [ContractorNumbers], [BidderNumbers] are both fields from other subqueries.
This works fine when [BidderNumbers] OR [ContractorNumbers] is 0, outputting 0 or 100% in either case, however if both [BidderNumbers] AND [ContractorNumbers] are 0, I get 0/0 and the query outputs #Num!
How can I change the field code to fix this?
OR, is there something else that I could do to fix the Bidder and Contractor queries that would avoid the 0/0 problem? Happy to link my database if that is the case.
THANKS!