SAC masterdata filter

[michele_medaglia5]

Hi SAC Friends

I am loading masterdata froma a query BW to SAC.

I was asked to filter only the WBS IDs starting with C so in SAC I wrote the below formula as you can see in the screenshot but it doesn't work.

Could you please help me?

thanks

Michele

wbs.jpg

[N1kh1l · Accepted solution]

michele.medaglia5

michele.medaglia5You can use something like below. Change your formula for like below.

Adjust as per your WBS column name.

IF(SUBSTRING([WBSKEY],0 ,1)="C",[WBSKEY] ,"NA")

This is how the result will look like

Hope it helps you.

Please upvote/accept if this helps

Nikhil

[michele_medaglia5]

thanks a lot Nikhil