使用计算字段过滤列表中的视图
我已经在共享点列表中创建了一个计算列,该列会查看"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.
欢呼