点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
我的表中有5个Term字段(Term 1,Term 2,Term 3,Term 4,Term 5)。如果它们中的任何一个等于这些值中的任何一个,我希望我的公式返回True。 如果5个条件中的任何一个都不等于这些值中的任何一个,我想返回false:
条款,120个月,72个月或84个月
下面的公式返回True,但从不返回false。 我应该怎么问问题的虚假部分?
如果([[Co-term]," 120个月"," 72个月"," 84个月"]中的{{opportunity.new_termoption1}),则为true,否则[[Co-term "," 120个月"," 72个月"," 84个月"])则为真,否则([" Co-term"," 120个月"," 72个月"," 84个月"中的{{opportunity.new_termoption3} ])则为true,否则为[{Co-term"," 120个月"," 72个月"," 84个月"]中的({opportunity.new_termoption5}),否则为true。 -term"," 120个月"," 72个月"," 84个月"]),则为true,否则为true({[Co-term"," 120个月"," 72个月","中的{opportunity.new_termoption1} 84个月"]),而不是([[Co-term"," 120个月"," 72个月"," 84个月"]]中的{opportunity.new_termoption2} 字词"," 120个月"," 72个月"," 84个月"])和否({[共同条款"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption4} )而不是({[Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption5}然后为假
您好,芭芭拉
尝试:
即使没有if-else语句,该公式也应得出true 或false
-Abhilash
这将返回True,但从不返回False。 我很困惑为什么不满足条件时它不会返回false。
嗨,
尝试以下脚本
谢谢-这也会返回True,但绝不会返回False。 我很困惑为什么。
我找到了! 我需要考虑该术语为null的情况。
这有效:
not(isnull({opportunity.new_termoption1}))和{opportunity.new_termoption1}在[" Co-term"," 120个月"," 72个月"," 84个月"]
或在[" Co-term"," 120个月"," 72个月"," 84个月"]中的not(isnull({opportunity.new_termoption2}))和{opportunity.new_termoption2}
或在[" Co-term"," 120个月"," 72个月"," 84个月"]中不(isnull({opportunity.new_termoption3}))和{opportunity.new_termoption3}
或在[" Co-term"," 120个月"," 72个月"," 84个月"]中的not(isnull({opportunity.new_termoption4}))和{opportunity.new_termoption4}
在[" Co-term"," 120个月"," 72个月"," 84个月"]中不使用(isnull({opportunity.new_termoption5}))和{opportunity.new_termoption5}
谢谢您的帮助!
一周热门 更多>