不正确的除零错误帮助 [英] Incorrect divide by zero error help

问题描述

我使用{fielda} / {fieldb}创建了一个公式来获得平均值。



问题是{fieldb}中的所有数据都会有更大的值比零。我收到Divide by 0错误消息。



我与{fielda} / {fieldb}具有相同公式的任何其他字段没有任何问题



基本上报告中总会有一个数量而不是价格，所以{TotalValue} / {Quantity}永远不能被0整除。



在这种情况下，它是$ 0/4。这应该等于0，但它会返回可归零的错误消息。



我在报告中使用了以下条款，但我担心它会搞砸未来的报告。



IF {fielda} = 0

那么0

ELSE {fielda} / {fieldb}



我很感激这方面的帮助。



我尝试了什么：



我在报告中使用了以下条款，但我担心它会搞砸未来的报道。



IF {fielda} = 0

那么0

ELSE {fielda} / {fieldb}

解决方案

0/4。这应该等于0，但它会返回可归零的错误消息。



我在报告中使用了以下条款，但我担心它会搞砸未来的报告。



IF {fielda} = 0

那么0

ELSE {fielda} / {fieldb}



我很感激这方面的帮助。



我尝试了什么：



我在报告中使用了以下条款，但我担心它会搞砸未来的报道。



IF {fielda} = 0

那么0

ELSE {fielda} / {fieldb}

我担心你检查错误的字段为零，请尝试：

 IF {fieldb} = 0 
 THEN 0 
 ELSE {fielda} / {fieldb} 

I created a formula using {fielda} / {fieldb} to get the average.

The issue is all data in {fieldb} will have a value greater than zero. I receive the Divide by 0 error message.

I do not have any problems with any of the other fields that have the same formula as {fielda} / {fieldb}

Basically there will always be a Quantity in the report but not a price so {TotalValue}/{Quantity} should never be divisible by 0.

In this case it is $0/4. This should equal 0 but instead it returns the divisible by zero error message.

I did use the following clause in the report but I am worried it will mess up future reporting.

IF {fielda} = 0
THEN 0
ELSE {fielda} / {fieldb}

I appreciate the help with this.

What I have tried:

I did use the following clause in the report but I am worried it will mess up future reporting.

IF {fielda} = 0
THEN 0
ELSE {fielda} / {fieldb}

解决方案

0/4. This should equal 0 but instead it returns the divisible by zero error message.

I did use the following clause in the report but I am worried it will mess up future reporting.

IF {fielda} = 0
THEN 0
ELSE {fielda} / {fieldb}

I appreciate the help with this.

What I have tried:

I did use the following clause in the report but I am worried it will mess up future reporting.

IF {fielda} = 0
THEN 0
ELSE {fielda} / {fieldb}

I fear you check the wrong field for zero, try:

IF {fieldb} = 0
THEN 0
ELSE {fielda} / {fieldb}

这篇关于不正确的除零错误帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！