或公式中的语句

2020-09-02 15:00发布

         点击此处--->   EasySAP.com群内免费提供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}然后为假

         点击此处--->   EasySAP.com群内免费提供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}然后为假

付费偷看设置
发送
5条回答
Alawn_Xu
1楼 · 2020-09-02 15:42.采纳回答

您好,芭芭拉

尝试:

 {opportunity.new_termoption1},位于["共同条款"," 120个月"," 72个月"," 84个月"]
 要么
 {op-"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption2}
 要么
 {op-"," 120个月"," 72个月"," 84个月"中的{opportunity.new_termoption3}
 要么
 {op-"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption4}
 要么
 {op-"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption5} 

即使没有if-else语句,该公式也应得出true 或false

-Abhilash

愤怒的猪头君
2楼-- · 2020-09-02 15:43

这将返回True,但从不返回False。 我很困惑为什么不满足条件时它不会返回false。

闻人可可
3楼-- · 2020-09-02 16:00

嗨,

尝试以下脚本

如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption1})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption2})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption3})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption4})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption5})则为true
 否则为false 
Haoba3210
4楼-- · 2020-09-02 15:33

谢谢-这也会返回True,但绝不会返回False。 我很困惑为什么。

DafaDDDa
5楼-- · 2020-09-02 15:55

我找到了! 我需要考虑该术语为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}

谢谢您的帮助!

一周热门 更多>