问题描述
任何人都可以帮助我尝试使用表达式构建器创建一个表达式，当公式尝试除以零时返回零。
到目前为止，我的尝试都失败了。
这是我到目前为止所尝试过的。我觉得我的逻辑是正确的，也许我的语法是关闭的。
Expr1：IIf（Bsheetcostdraft！[CSA / SAA] = 0,0，Icostcostdraft！[CSA / SAA] / Bsheetcostdraft！[CSA / SAA]）
任何人都可以引导我完成这个。
Can anyone Help I am trying to use the expression builder to create an expression that returns a zero when a formula tries to divide by zero.
So far my attempts have failed.
This is what I have tried so far. I feel my logic is correct maybe my syntax is off.
Expr1: IIf(Bsheetcostdraft![CSA/SAA]=0,0,Icostcostdraft![CSA/SAA]/Bsheetcostdraft![CSA/SAA])
Can anyone guide me through this.
推荐答案
我尝试切换！对于。无济于事，我知道我的命名惯例似乎很奇怪，但它们是正确的。我真的被困在这里。你甚至可以在选择查询的空格标记字段中放置这样的表达式。
I did try switching the "!" for "." To no avail and I know my naming conventions seem wierd but they are correct. I really stranded here. Can you even put an expression like this in the space marked field for a select query.
这篇关于访问问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！