List 的计算列如何汇总

forum2621 2010-02-02 06:05:01
如题,创建一个list,创建几个栏,其中一栏是 计算值(基于其他栏的计算), 此列怎么汇总?在视图设计页面没看到此栏的信息...
...全文
217 8 打赏 收藏 举报
写回复
8 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
forum2621 2010-02-10
  • 打赏
  • 举报
回复
引用 7 楼 time_is_life 的回复:
3.用JQuery:
http://www.endusersharepoint.com/2009/01/06/jquery-for-everyone-total-calculated-columns/


效果不错,结贴
time_is_life 2010-02-02
  • 打赏
  • 举报
回复
3.用JQuery:
http://www.endusersharepoint.com/2009/01/06/jquery-for-everyone-total-calculated-columns/
time_is_life 2010-02-02
  • 打赏
  • 举报
回复
有两种方法:
1.用工作流:



Let’s say we have a field called PROFIT that is a calculated field set to subtrack the expense field from the revenue field in our list. ([Revenue]-[Expense])

1. Create a regular number field (or currency field) called TOTAL PROFIT (or any other name you want) in that list.
2. Using SharePoint Designer create a workflow for your list that runs when list items are created and when list items are changed.
3. The workflow will have only one step name it something like set TOTAL PROFIT.Leave the condition field blank.
4. In the action section choose “Set field in the current item”.
5. Click on the word “field” and choose TOTAL PROFIT (the name of our column).
6. Click on the word “value” and click on the “fx” button to do a lookup.
7. Choose “Current Item” for the source.
8. Choose “PROFIT” for the field. (This is the calculated column.)
9. Click Finish.




2. 用SharePoint Desinger:

http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2009/04/24/how-to-total-calculated-columns-in-a-sharepoint-list.aspx
forum2621 2010-02-02
  • 打赏
  • 举报
回复
[Quote=引用 4 楼 foxdave 的回复:]
不能汇总啊……
[/Quote]

不能汇总,能不能有方法让它汇总,比如改写系统api(这个难度好像很大哦)
Justin-Liu 2010-02-02
  • 打赏
  • 举报
回复
不能汇总啊……
forum2621 2010-02-02
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 cshadow 的回复:]
计算列就是不能汇总现在。。。你可以写一个eventhandler,把计算列的值在添加和编辑时写到一个单行文本里,然后用单行文本汇总
[/Quote]

我也是这么想得,数据多了,效率太低了啊
gannian 2010-02-02
  • 打赏
  • 举报
回复
FLEX???
cshadow 2010-02-02
  • 打赏
  • 举报
回复
计算列就是不能汇总现在。。。你可以写一个eventhandler,把计算列的值在添加和编辑时写到一个单行文本里,然后用单行文本汇总
发帖
SharePoint

3239

社区成员

企业开发 SharePoint
社区管理员
  • SharePoint社区
  • 霖雨
加入社区
帖子事件
创建了帖子
2010-02-02 06:05
社区公告
暂无公告