INFOPATH计算帮助 [英] INFOPATH HELP ON CALCULATIONS
问题描述
我不熟悉,并且有一个截止日期,要求Infopath在列中仅添加某些数字-不能全部添加.
I'm unfamiliar and have a deadline to make Infopath add only certain numbers in a column - not the whole thing.
我的数据显示了一个雇员列表,他们的区域和他们的时间.即鲍勃·史密斯(Bob Smith),零售,工作10小时
My data shows a list of employees, their area and their time. i.e., Bob Smith, retail, 10 hours
如果鲍勃·史密斯(Bob Smith)也有鲍勃·史密斯(Bob Smith)的照片(20小时),它将在另一行.
If Bob Smith also has Bob Smith, photo, 20 hours, it is on a separate row.
列表中我还有其他员工,他们只有1行,他们的信息显示了他们的姓名,部门和40小时.
I have other employees on the list who only have 1 row and their info shows their name, division and 40 hours.
我需要做的是让信息路径添加每个人的信息,并在另一个表上向我显示每个人的总工作时间.
What I need to do is have Info path add the information for each person and show me the total on another table of what each person's total hours are.
我可以对它进行排序并向我显示员工,但是它不允许我添加每个人的行,而又不想添加该列的全部信息.我需要知道每个员工有几个小时.那我怎么把鲍勃的时间加起来 Smith不想添加所有员工的整个列.
I can have it sort and show me employees but it doesn't let me add each person's row without wanting to add the entire information for the column. I need to know how many hours each employee has. So how do i have it add just the hours for Bob Smith without it wanting to add the entire column of all employees.
推荐答案
嗨Nanette美国能源部,
如何插入数据?您从数据连接中获取数据了吗?您是否在使用重复表?请提供有关您的情况的更多信息和屏幕截图,以帮助我们解决您的问题 问题.
How do you insert the data? Have you get data from a data connection? Are you using a Repeating Table? Please provide more information and screenshots about your situation for helping us solving your issue.
如果您从数据连接中获取数据并将其显示在重复表上,则可以添加文本框来计算一个人的小时数.
1.我创建一个重复表并为此表添加数据连接以从列表中检索数据.
2.在表格下添加一个文本框,然后编辑该文本框.单击值"选项旁边的按钮,然后插入求和函数.
3.点击双击以插入字段"要编辑求和函数,请为字段"选项选择数据连接,然后选择时间".然后点击过滤数据"以添加以下条件:
员工=鲍勃·史密斯"
预览表单时,您会发现以下结果:
最好的问候,
艾伦·白
这篇关于INFOPATH计算帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!