公式无法正常工作

2020-09-21 14:17发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我正在使用以下公式。 该报告仍在拉扯下面带有粗体字代码的患者。 不知道我需要做什么来解决它。 有修复程序吗?

如果({GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS_Op.GROUPER_ID} ='100667'和{CL_ICD_PX.REF_BILL_CODE})

(([" D78.21"," D78.22"," E89.810"," E89.811"," G97.51"," G97.61"," G97。"中的{CLARITY_EDG_FinalDX.CURRENT_ICD10_LIST} 52"," H59.311"," H59.312"," H59.313"," H59.319"," H59.321"," H59,322"," H59.323"," H59.329" ," H95.41"," H95.42"," I97.610"," I97.611"," I97.618"," I97.62"," J95.830"," J95.831"," K91.840"," K91.841"," L76.21"," L76.22"," M96.830"," M96.831"," N99.820"," N99.821"]和{HSP_ACCT_DX_LIST .LINE} <> 1)

({GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS.GROUPER_ID} ='100669'和{CL_ICD_PX.REF_BILL_CODE})

不是([" D47.3"," D65"," D66"," D67"," D68.0"," D68.1"," D68.2"中的{CLARITY_EDG_FinalDX.CURRENT_ICD10_LIST} ," D68.311"," D68.312"," D68.318"," D68.32"," D68.4"," D68.8"," D68.9"," D69.1"," D69.3"," D69.41"," D69.42"," D69.49"," D69.51"," D69.6"," D69.8"," D69.9"]),然后为true

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我正在使用以下公式。 该报告仍在拉扯下面带有粗体字代码的患者。 不知道我需要做什么来解决它。 有修复程序吗?

如果({GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS_Op.GROUPER_ID} ='100667'和{CL_ICD_PX.REF_BILL_CODE})

(([" D78.21"," D78.22"," E89.810"," E89.811"," G97.51"," G97.61"," G97。"中的{CLARITY_EDG_FinalDX.CURRENT_ICD10_LIST} 52"," H59.311"," H59.312"," H59.313"," H59.319"," H59.321"," H59,322"," H59.323"," H59.329" ," H95.41"," H95.42"," I97.610"," I97.611"," I97.618"," I97.62"," J95.830"," J95.831"," K91.840"," K91.841"," L76.21"," L76.22"," M96.830"," M96.831"," N99.820"," N99.821"]和{HSP_ACCT_DX_LIST .LINE} <> 1)

({GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS.GROUPER_ID} ='100669'和{CL_ICD_PX.REF_BILL_CODE})

不是([" D47.3"," D65"," D66"," D67"," D68.0"," D68.1"," D68.2"中的{CLARITY_EDG_FinalDX.CURRENT_ICD10_LIST} ," D68.311"," D68.312"," D68.318"," D68.32"," D68.4"," D68.8"," D68.9"," D69.1"," D69.3"," D69.41"," D69.42"," D69.49"," D69.51"," D69.6"," D69.8"," D69.9"]),然后为true

付费偷看设置
发送
2条回答
梦想连接
1楼-- · 2020-09-21 14:52

如果选择公式中包含"或"和"与",则用括号将语句分开,以更好地理解逻辑。

闻人可可
2楼-- · 2020-09-21 15:13

此外,如果这在您的选择标准中(选择专家),请除去If语句。 因此可能看起来像这样:

(({GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS_Op.GROUPER_ID} ='100667'和{CL_ICD_PX.REF_BILL_CODE})

(([" D78.21"," D78.22"," E89.810"," E89.811"," G97.51"," G97.61"," G97。 52"," H59.311"," H59.312"," H59.313"," H59.319"," H59.321"," H59,322"," H59.323"," H59.329" ," H95.41"," H95.42"," I97.610"," I97.611"," I97.618"," I97.62"," J95.830"," J95.831"," K91.840"," K91.841"," L76.21"," L76.22"," M96.830"," M96.831"," N99.820"," N99.821"]和{HSP_ACCT_DX_LIST .LINE} <> 1)

({{GROUPER_RECORDS.GROUPER_REC_LIST}中的{GROUPER_RECORDS.GROUPER_ID} ='100669'和{CL_ICD_PX.REF_BILL_CODE})

不是([" D47.3"," D65"," D66"," D67"," D68.0"," D68.1"," D68.2"," D68"中的{{CLARITY_EDG_FinalDX.CURRENT_ICD10_LIST} .311"," D68.312"," D68.318"," D68.32"," D68.4"," D68.8"," D68.9"," D69.1"," D69.3 "," D69.41"," D69.42"," D69.49"," D69.51"," D69.6"," D69.8"," D69.9"])

在Select Expert中使用" If"语句时,Crystal很有可能会在从数据库中拉出所有未过滤的数据后在内存中对其进行处理,从而大大降低了报告速度。 由于每个语句本身的计算结果为True或False,因此您不需要" If .... Then true"。

-戴尔

一周热门 更多>