使用计算字段过滤列表中的视图 [英] Filtering views in a list using a calculated field

问题描述

我已经在共享点列表中创建了一个计算列，该列会查看"created"字段，然后标识月份值(即2008年1月2日的月份值等于1) = MONTH([已创建])

I have created a calculated column in a sharepoint list which looks at the 'created' field and then identifies the month value (i.e the month value for 2nd January 2008 would equals 1) =MONTH([Created])

这很棒.

但是，现在我试图基于此列过滤视图，并且它不返回任何项目.

However, now I'm trying to filter a view based on this column and it returns no items.

有没有人注意到在SharePoint中您不能筛选列表，该列表的筛选器基于计算所得的列?

Has anyone noticed that in SharePoint you can't filter a list where the filter is based on a calculated column?

我已经在其他计算出的列上运行了一些测试，并且发生了同样的事情.为什么会这样呢?看起来很奇怪.

I have run some tests on other calculated columns and the same thing occurs. Why would this be? It seems strange.

谢谢.

推荐答案

为有兴趣的人想出了一个.

真的很简单-只需将我的计算字段小数位设置设置为0，现在就可以使用了.

Really simple - just needed to set my calculated field decimal place setting to 0 and now it works.

欢呼

这篇关于使用计算字段过滤列表中的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！