Divide By Zero with Nz? (1 Viewer)

[scouser]

Hi to all. A query is returning #Div/0!.

The sum is as follows:
Line Total = 0
CostPrice = 3.32

I thought the addition of Nz would resolve this but maybe I am adding incorrectly.

Margin: Nz([tblSalesOrderDetails].[LineTotal]-[tblSalesOrderDetails.CostPrice],0)/[tblSalesOrderDetails].[LineTotal]

Thansks,
Phil.

 

[scouser]

Can anyone see an issue with using the following:

Margin: IIf([tblSalesOrderDetails].[LineTotal]-[tblSalesOrderDetails.CostPrice]<>0,Null,[tblSalesOrderDetails].[LineTotal]-[tblSalesOrderDetails.CostPrice])/[tblSalesOrderDetails].[LineTotal]

Phil

 

[Ranman256]

its division by zero. Numerator zero is fine.

IIF([tblSalesOrderDetails].[LineTotal] = 0,0,NZ([tblSalesOrderDetails].[LineTotal]-[tblSalesOrderDetails.CostPrice])/[tblSalesOrderDetails].[LineTotal])

 

[arnelgp]

XMargin: Nz([tblSalesOrderDetails].[LineTotal],0)-Nz([tblSalesOrderDetails.CostPrice],0)/Nz([tblSalesOrderDetails].[LineTotal], 1)