Simple if else formula failing. / Formula (64) String variable switched type Record #4

[Hamder83]

HI 

I have two values I wanna pass through this formula:
1.: [SubCarrierNameUB] = 'GLS Austria Parcel'
2.: ParcelNumberPurchase

Both fields are text.

Then I generate a new field in a forumla:
IntegrationParcelNumber which is text too.

And I do this formula:

if

[SubCarrierNameUB] = 'InPost Parcel'
THEN
[ParcelNumberPurchase]

ELSEIF
[SubCarrierNameUB] = 'Bring Denmark Parcel'

and left([ParcelNumberPurchase], 2) != '00'
THEN
"00"+[ParcelNumberPurchase]

ELSEIF
[SubCarrierNameUB] = 'Bring Denmark Parcel'

and left([ParcelNumberPurchase], 2) = '00'
THEN
[ParcelNumberPurchase]

ELSEIF
[SubCarrierNameUB] = 'Postnord Norway Parcel'
AND
StartsWith([ParcelNumberPurchase], "707")
THEN
[ParcelNumberPurchase]

ELSEIF
[SubCarrierNameUB] = 'GLS Germany Parcel'
AND
StartsWith([ReceiversReference], "00157") or
StartsWith([ReceiversReference], "00257") or
StartsWith([ReceiversReference], "00557") or
StartsWith([ReceiversReference], "00657") or
StartsWith([ReceiversReference], "00957")
THEN
[ReceiversReference]

ELSEIF

[SubCarrierNameUB] = 'GLS Germany Parcel'
AND
StartsWith([SendersReference], "00157") or
StartsWith([SendersReference], "00257") or
StartsWith([SendersReference], "00557") or
StartsWith([SendersReference], "00657") or
StartsWith([SendersReference], "00957")
THEN
[SendersReference]

ELSEIF
[SubCarrierNameUB] = 'GLS France Parcel'
AND
StartsWith([OrderNumberCustomer], "00157") or
StartsWith([OrderNumberCustomer], "00257") or
StartsWith([OrderNumberCustomer], "00557") or
StartsWith([OrderNumberCustomer], "00657") or
StartsWith([OrderNumberCustomer], "00957")
THEN
[OrderNumberCustomer]

ELSEIF
[SubCarrierNameUB] = 'GLS Ireland Parcel'
AND
StartsWith([ReferenceCustomer], "00157") or
StartsWith([ReferenceCustomer], "00257") or
StartsWith([ReferenceCustomer], "00557") or
StartsWith([ReferenceCustomer], "00657") or
StartsWith([ReferenceCustomer], "00957")
THEN
[ReferenceCustomer]

ELSEIF
[SubCarrierNameUB] = 'GLS Germany Parcel'
and
Length([ParcelNumberPurchase]) = 12
THEN
Left([ParcelNumberPurchase], 11)

ELSEIF
[SubCarrierNameUB] = 'DHL Netherlands Parcel'
THEN
"00"+[ParcelNumberPurchase]

ELSEIF

[SubCarrierNameUB] = 'GLS Belgium Parcel'
AND
StartsWith([SendersReference], "00157") or
StartsWith([SendersReference], "00257") or
StartsWith([SendersReference], "00557") or
StartsWith([SendersReference], "00657") or
StartsWith([SendersReference], "00957")
THEN
[SendersReference]

ELSE
[ParcelNumberPurchase]

ENDIF

Since the subcarrier is not in this list, I expected it to just fill ParcelNumberPurchase into my new IntegrationParcelNumber?
But it comes out empty:

[atcodedog05]

Hi @Hamder83 

Can you share your formula tool config?