或公式中的语句

2020-09-02 15:00发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我的表中有5个Term字段(Te...

         点击此处--->   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条回答
DafaDDDa
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}

谢谢您的帮助!

一周热门 更多>