there is a column called "customer", It has four letter data in it for ex: "ABCD". I am trying to create a Calculated column , which will have all the data starts with "A" from customer column and only display last two letters ( in this case : "cd") in that column.
your response is highly appreciable.
Thanks.
CASE WHEN
[Customer] like 'A%'
then (substring([Customer,3,2))
else (null)
As definition of the calculated data-item..