问题描述
我正在数据库中工作并创建一个报告，该报告将带来大约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?
推荐答案
= IIf（IsNull（[401K
=IIf(IsNull([401K
]
这篇关于具有空值的表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！