Question
--------
My formula does not work for a field (in the following
example for field ‘numberC’) in my inbound formula. For
demonstration purposes, I will use fields ‘numberA’,
‘numberB’, and ‘numberC’.
PO1 POSITION 8 Line 50 Qualifier field mapped to ‘V’
PO1 POSITION 8 Line 51 Qualifier field mapped to ‘V’
PO1 POSITION 9
mapped to field ‘numberA’
Line 50 Formula: if |ELEMENT|[9] = ‘V’ THEN ‘A’ ELSE ‘B’
PO1 POSITION 9
mapped to field ‘numberB’
Line 51 Formula: if |ELEMENT|[9] = ‘V’ THEN ‘A’ ELSE ‘B’
PO1 POSITION 10
mapped to field ‘numberC’
Line 52 Formula: if |ELEMENT|[9] = ‘V’ THEN ‘A’ ELSE ‘B’
Answer
------
Even though you verify the prior |ELEMENT| in the formula,
you must still map the prior position’s qualifier.
Here is what you are missing:
PO1 POSITION 8 Line 52 Qualifier field mapped to ‘V’
Here are some more tips for formulas:
1.Have you put appropriate brackets within your formula?
2.Have you generated your formulas?
3.Do you have other mapping references to that field that
might overwrite this mapping?