2020-09-20 01:15发布
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
= If(IsError(ToNumber(Replace([Total Budget];",";"")))-[Expenditures]);""; ToNumber(Replace([Total Budget];",";"") )-[支出]-[预支款]-[预支款])
多种实现方法。
Option1值将是字符串数据类型
If(IsError(ToNumber(Replace([Total Budget];",";"")))-[Expenditures]);"" ;; formatnumber(ToNumber(Replace([Total Budget];",";"" ))-[支出]-[预支款]-[预支款]);" 0.00")
选项2在公式中将""替换为0。之后,右键单击column-formatnumber-number-custom并添加值0.00,然后单击"确定"
If(IsError(ToNumber(Replace([Total Budget];",";"")))-[Expenditures]); 0; ToNumber(Replace([Total Budget];",";""))- [支出]-[预支款]-[预支款])
最多设置5个标签!
多种实现方法。
Option1值将是字符串数据类型
If(IsError(ToNumber(Replace([Total Budget];",";"")))-[Expenditures]);"" ;; formatnumber(ToNumber(Replace([Total Budget];",";"" ))-[支出]-[预支款]-[预支款]);" 0.00")
选项2在公式中将""替换为0。之后,右键单击column-formatnumber-number-custom并添加值0.00,然后单击"确定"
If(IsError(ToNumber(Replace([Total Budget];",";"")))-[Expenditures]); 0; ToNumber(Replace([Total Budget];",";""))- [支出]-[预支款]-[预支款])
一周热门 更多>