When you add a function field, what does the "Check" button actually return? I understand that it checks the script, but in some cases I've found that it returns the result as "@@ORG:RECTYPE@@" which is the field I assigned to the ScriptedField variable.
However in the function below, its returning "Other" even though all the records in my source data have a value of "A".
'TODO: your custom VBScript code here
If "@@ORG:RECTYPE@@"="M" or "@@ORG:RECTYPE@@"="C" Then
ElseIf "@@ORG:RECTYPE@@"="A" Then
So I'm unsure of what exactly is being returned by the test.
Login or sign up for our forums to connect to the user community.