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: