计算字段帮助 [英] Calculated Field Help

问题描述

我有一个使用以下逻辑的计算字段

= IF(ISERR(FIND(-NG"，[Oppo rtunity名称]))，"，MID([Opportunit y名称]，FIND(-NG"，[Opportun ity名称])+ 1，MINA(FIND("，"[Opportunity Name]"和"，FIND(-NG"，[Opportunity Name]))，FIND(- "，[机会 ity 名称]&-"，FIND(-NG"，[Oppo

I have a calculated field that uses the below logic

=IF(ISERR(FIND("-NG",[Opportunity Name])),"",MID([Opportunity Name],FIND("-NG",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-NG",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-NG",[Opportunity Name])+1))-FIND("-NG",[Opportunity Name])-1))

我的问题是如何更改它，以便它不仅查找-NG，而且查找-NG或-HP并处理所有其他相同内容

my question is how can I alter that so it looks for not just -NG but -NG or -HP and handles all else the same

推荐答案

您可以尝试以下方法:

= IF(IF( ISERR(FIND(-NG"，[机会名称]))，"，MID([机会名称]，FIND(-NG"，[机会名称])+ 1，MINA(FIND("; ，[商机名称]&" ",, FIND(-NG"，[机会名称]))，FIND(-"，[机会名称]&-"，FIND(-NG"，[机会名称] )+1))-FIND(-NG"，[机会名称])-1))="，IF(ISERR(FIND(-HP"，[机会] 名称]))，"，MID([机会名称]，FIND(-HP"，[机会名称])+ 1，MINA(FIND("，"[机会名称]"& ",, FIND(-HP"，[机会名称]))，FIND(-"，[机会名称]&-"，FIND(-HP" ,，机会") 名称]] + 1))-FIND(-HP"，[机会名称])-1)))，IF(ISERR(FIND(-NG"，[机会名称]))，"， MID([机会名称]，FIND(-NG"，[机会名称])+ 1，MINA(FIND("，， [机会名称]"&"，FIND(-NG") ，[机会 名称]))，FIND(-"，[机会名称]&-"，FIND(-NG"，[机会名称])+ 1))-FIND(-NG") ，[商机名称])-1))))

=IF(IF(ISERR(FIND("-NG",[Opportunity Name])),"",MID([Opportunity Name],FIND("-NG",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-NG",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-NG",[Opportunity Name])+1))-FIND("-NG",[Opportunity Name])-1))="",IF(ISERR(FIND("-HP",[Opportunity Name])),"",MID([Opportunity Name],FIND("-HP",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-HP",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-HP",[Opportunity Name])+1))-FIND("-HP",[Opportunity Name])-1)),IF(ISERR(FIND("-NG",[Opportunity Name])),"",MID([Opportunity Name],FIND("-NG",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-NG",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-NG",[Opportunity Name])+1))-FIND("-NG",[Opportunity Name])-1)))

或者您可以为此创建3个计算列:

第一个字段[cal]:

= IF(ISERR(FIND(-HP"，[商机名称]))，"，MID([商机名称]，FIND(-HP"，[商机名称])+ 1，MINA(FIND(")，[商机] 名称]&" ，FIND(-HP"，[机会名称]))，FIND(-"，[机会名称]&-"，FIND(-HP"，[机会名称] )+1))-FIND(-HP"，[商机名称])-1)))

=IF(ISERR(FIND("-HP",[Opportunity Name])),"",MID([Opportunity Name],FIND("-HP",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-HP",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-HP",[Opportunity Name])+1))-FIND("-HP",[Opportunity Name])-1))

第二个字段[cal1]:

= IF(ISERR(FIND(-NG" ,, [商机名称]))，"，MID([商机名称]，FIND(-NG"，[商机名称])+ 1，MINA(FIND(")，[商机] 名称]&" ",, FIND(-NG"，[机会名称]))，FIND(-"，[机会名称]&-"，FIND(-NG"，[机会名称] )+1))-FIND(-NG"，[机会名称])-1)))

=IF(ISERR(FIND("-NG",[Opportunity Name])),"",MID([Opportunity Name],FIND("-NG",[Opportunity Name])+1,MINA(FIND(" ",[Opportunity Name]&" ",FIND("-NG",[Opportunity Name])),FIND("-",[Opportunity Name]&"-",FIND("-NG",[Opportunity Name])+1))-FIND("-NG",[Opportunity Name])-1))

最后一个字段[cal2]:

= IF(cal ="，cal1，cal)

您可以在列表视图中为用户隐藏cal和cal1.

最好的问候，

Lee

这篇关于计算字段帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！