Skip to Content
0
Feb 02, 2021 at 01:09 PM

concatenate column value in sap calculation view

52 Views

Hello Expert,

i need to have a calculated column in calculation view where need to concatenate the value of multiple column values seperated by '/'.

if we do like

"ACT_QA_D" + '/' + "COMPLIANCE_D" +'/' +"NF_D" + '/' +"RCP_APP_GEN_D" +'/' +"RCP_APP_DEV_D" + '/' +"RCP_APP_SITE_D" + '/' +"READY_FOR_MAN_D"

But issue is if "COMPLIANCE_D" is blank then the output comes like

xx//yy/zz

How we can have output like

xx/yy/zz

Thanks