具有空值的表达式 [英] Expression with null value

问题描述

我正在数据库中工作并创建一个报告，该报告将带来大约150条记录。每份报告都是2页并且是个性化的。

I am working in a database and creating a report that will bring in approximately 150 records. Each report is 2 pages and individualized.

我有数据（$），然后我试图显示雇主和员工贡献之间的百分比分配。这是我开始的表达：

I've got data ($) that I am then trying to show the percentage split between employer and employee contribution. This is the expression I started with:

= [401K $ - 雇主供款] /（[401K $ - 雇员供款] + [401K $ - 雇主供款] + [ROTH 401K $ - 员工贡献]）b

=[401K $ - Employer Contribution]/([401K $ - Employee Contribution]+[401K $ - Employer Contribution]+[ROTH 401K $ - Employee Contribution])

然后我意识到某些记录在这些字段的一个或多个中将具有零值，因此会产生" #NUM "结果。我认为Iif表达式是正确的方法，但我无法正确使用语法。
我尝试过"IsNull"，"Nz"，嵌套"Iif"。表达式，但没有任何工作。 

Then I realized that some of the records would have a zero value in one or multiple of those fields and therefore would produce a "#NUM" result. I'm thinking that an Iif expression would be the right way but I can't get the syntax right. I've tried "IsNull", "Nz", nested "Iif" expressions but nothing is working. 

有没有人对如何做到这一点有任何想法？

Does anyone have any thoughts on how to do this?

推荐答案

您可以在文本框ControlSource中尝试：

You can try this in a textbox ControlSource:

= IIf（IsNull（[401K

=IIf(IsNull([401K

]

- 雇主贡献]），Null，[401K

- Employer Contribution]),Null,[401K

- 雇主贡献] /（[401K

- Employer Contribution]/([401K

这篇关于具有空值的表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！