Skip to Content
0
Feb 13, 2019 at 11:29 PM

Webi Variable Help / Remove Character Based On Another Column

59 Views

Hello,

I have a report that has 2 columns as below

ID Group

F562 A

D123 B

863 C

What I need to do is display as follows:

ID Group

562 A

123 B

863 C

So, If the group is A or B, remove the first character of the ID column. If Group C, leave as is.

Any Ideas?

Thanks in Advance.