Using RIGHT function with a list
I have a field that is a list format (itemcode), and it has a 3 letter code at the end of each item (e.g product1-abc123-regular-CNC). In another field i want to check this code before carrying out a calculation.
IF RIGHT(itemcode,3) = "CNC" THEN 1 ELSE 0
I cannot use RIGHT(itemcode,3) as it is not TEXT, how can i use RIGHT with a list item ?