不要显示零值

本文介绍了不要显示零值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我创建了一个列表，这是SharePoint中的技能评估，我有几种内容类型：Microsoft Excel，Microsoft Word等...

每种类型都有一个不同的问题集，这就是为什么我这样设置，所以管理者可以选择要采取的技能评估类型。经理选择新项目的下拉菜单并选择评估。每个都有自己的形式。如果为Excel员工创建了的评估，则所有问题响应的总分（列表计算字段），则该用户的Word有一个字段（列出计算字段）显示零值。我如何做到这一点，所以现场没有？

另外，作为旁注，一个人可能需要多次评估，我必须创建一个单独的项目。可以这样做吗？所以他们的所有评估分数都显示在一条线上？那可能会摆脱这个问题吗？

请帮忙。

谢谢你，我感谢你的帮助。顺便说一句，我不是程序员，所以我对代码非常不满意。

解决方案

嗨Monika，关于你的上一个问题 - 这是因为你已经浏览了内容类型。通过这样做，您只显示该内容类型的字段。为一个人创建一个条目的唯一方法是允许他们一次输入多个内容类型。也许准备好将所有内容组合在一起的内容类型虽然在那时你可能需要为每个组合使用一个（如果你有4种内容类型，数学是4！或24种组合）。

其他解决方案可能是代​​码或InfoPath。使用代码，您可以根据选择确定显示哪些字段。 InfoPath可以提供不同的选项卡来对相似字段进行分组，并允许用户轻松查看所有字段而不会将某些字段锁定。

至于零在列中，这取决于你如何做到这一点，但假设你坚持使用非代码方法，你可以设置一个IF，说明如果你的总和是0，不显示任何东西。

如果你的公式是："=（A + B + C + D）"

那么它将是："= IF（（A + B + C +） d）= 0，""，A + B + C + d）"

I createdone list which is a skills assessment in SharePoint and I have several content types: Microsoft Excel, Microsoft Word, etc...

Each Type has a different set of questions which is why I set it up this way, so managers can choose the type of skills assessment to take. Managers choose the drop down for New Item and choose the assessment. Each has their own form. If an assessment iscreated for an employee for Excel, there is a (list calculated field) total score of all the questions responses, then there is a field(list calculated field)for Word for that user that displays a zero value. How do I make it so the there is nothing in the field?

Also, as a side note, one person may take multiple assessments, for which I have to create a separate item. Can this be done differently? So all their assessment scores show up on one line? That may get rid of that issue?

Please help.

Thank you and I appreciate your help on this. BTW, I am not a programmer so I'm VERY iffy on code.

解决方案

Hi Monika, as for your last question - this is because you've went through content types. By doing so, you only present the fields that are present for that content type. The only way to have one entry for a person is to allow them to enter multiple of the content types at once. Perhaps ready a content type that combines them all. Though at that point you would potentially need one for every combination (if you have 4 content types the math is 4! or 24 combinations).

Other solutions would be either code or InfoPath. With code you could determine which fields display based on their selections. InfoPath could provide different tabs to group similar fields and allow users to easily see all fields without locking some away.

As for the zeros in columns, it depends on how you do the above, but assuming you stick with the non-code approach, you can put an IF that says if your sum is 0 to not display anything.

If your formula is: "=(A+B+C+D)"

Then it would be: "=IF((A+B+C+D)=0,"",A+B+C+D)"