问题描述
我有一个使用以下逻辑的计算字段
= 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
这篇关于计算字段帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！