InfoPath 2010公式无法正常工作 [英] InfoPath 2010 Formula is not working
问题描述
您好,
我已经在SharePoint网站中创建了基于InfoPath表单的列表,我已经将总计"字段作为数字数据类型和12个字段,例如"Jan,Feb,Mar,Apr,May ... Dec"作为数字字段.
I have created InfoPath form based list in SharePoint site, i have "Total" field as number data type and 12 fileds like "Jan,Feb,Mar,Apr,May...Dec" as number fields.
我正在使用公式来确保总计"字段值等于12个字段("Jan,Feb,Mar,Apr,May ... Dec")值的总和.
I am using formula to make sure "Total" field value is equal to sum of 12 fields("Jan,Feb,Mar,Apr,May...Dec") values.
当我使用十进制值时,它无法正常工作.即使我输入正确的十进制值.
When i use decimal values , its not working correctly. Even i enter correct decimal values.
Jeeva
推荐答案
你好,
总计"字段的数据类型是什么?它可以保留小数吗?
what is the data type of the Total field? Does it hold decimals?
要进行故障排除,您可以在表单上创建多个计算字段:
To troubleshoot, you can create several calculated fields on your form:
-一个添加所有月份的字段
- a field that adds all the months
-总字段
-将总字段与所有月份的总和进行比较的字段(总计=(一月+二月+三月.... +十二月))-这将为TRUE或FALSE.
- a field that compares the total field with the sum of all the months (total = (Jan + Feb + Mar .... + Dec)) -- This will be TRUE or FALSE.
这些字段显示什么?
这篇关于InfoPath 2010公式无法正常工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!