@Steve , thanks I removed the extra comma and added the “-” minus sign. Seems to be working
On my “Invalid Value Error” formula the formula Error Messages I had to change around to evaluate and display as per the scenario, but the messages does not relate to the formulas
IF([VisitorIDNumberIndicator] = “SA ID”, IF(10-NUMBER(RIGHT(TEXT([IDNumberValidateOne] + [IDNumberValidateThree]),1)) = RIGHT([_THIS],1),TRUE, FALSE), [_THIS])
"This ID Number ALREADY EXISTS"
([_THISROW].[VisitorIDNumber] = [VisitorIDNumber])
"The SA ID Number is NOT VALID"
So “This ID Number ALREADY EXISTS” should be with “your” formula and “The SA ID Number is NOT VALID” should be with the top part of the validation formula