本文介绍了具有空值的表达式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在数据库中工作并创建一个报告,该报告将带来大约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


]



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

07-17 04:21