I am trying to use the Right Function
I have a Column called system with values
- System A
- System R
I want to Display
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?