Help with Right()

[Martina_Hawkins]

I am trying to use the Right Function

I have a Column called system with values

1. System A
2. System R
   etc.

I want to Display
System A
System R

The numbering is to sort them in required order.

I have a formula in the System column

this does not work but if I create a VC with same formula the correct value shows.

Do I have to use a VC, can you not perform a Right() on the same Column?