Some samples from Germany, of how they use the Dynamic Field expressions.


All nested as always in the configration of the field in ONE line. I only show it here 

in multiply lines for a better overview


split field with 2 Values

FIRSTWORD('[Packungsangabe]') new field called PackungMenge

LASTWORD('[Packungsangabe]')  new field called Packungsangabe


Is the field numeric then OK else move 0 to the field. 

IF(ISNUMERIC([PackungsMgMix]),'[PackungsMgMix]','0')


Nested IF's with operators

Determine basic units for Liter/ml and Kilogramm/g

As always in the configration of the field in ONE line.


IF(DECIMAL('[PackungsMenge]')<=250&&'[PackungsEH]'='ml','100 ml',

IF(DECIMAL('[PackungsMenge]')<=250&&'[PackungsEH]'='g','100 g',

IF(DECIMAL('[PackungsMenge]')>250&&'[PackungsEH]'='g','1 KG',

IF(DECIMAL('[PackungsMenge]')>250&&'[PackungsEH]'='ml','1 L',

''))))



Germany basicprice is per 100 g if the product <=250 g or 1 KG if over 250 g, same for ml and Liter

I make a calculation field called GrdPreisCalc

IF(DECIMAL('[PackungsMenge]')<=250&&'[PackungsEH]'='g','100',

IF(DECIMAL('[PackungsMenge]')>250&&'[PackungsEH]'='g','1000',

IF(DECIMAL('[PackungsMenge]')<=250&&'[PackungsEH]'='ml','100',

IF(DECIMAL('[PackungsMenge]')>250&&'[PackungsEH]'='ml','1000',

''))))


filling a template field 

IF(DECIMAL('[Aktionspreis]')>0,'Aktion',

IF(DECIMAL('[Aktionspreis]')=0&&DECIMAL('[EVK]')>0,'EVK',

'UVP'))



fields "VK_UVP;EVK and Aktionspreis" contains the prices and we have to calculate the ground price. if the field "VK_UVP" empty the field leave with zero

otherwise the groundprice will be calculated with to other dynamic fields called PackungsMenge and GrdPreisCalc

sample for VK_UVP

IF(DECIMAL([VK_UVP])>0,ROUND(MULTIPLY(DIVIDE(DECIMAL([VK_UVP]),[PackungsMenge]),[GrdPreisCalc]),2),'0')


If Aktionspreis = empty than the value from Field "Layout" otherweise set value "Aktion" into the template field 

IF(('[Aktionspreis]') = (''),'[Layout]','Aktion')


If field has a value from the iNLIST value "gr" is set otherwise "empty" for Designer dependency steering

IF(iNLIST('[PE]','KG','kg','kG','Kg'),'gr',' ')


simple calculation with rounding to calculate a 100gr price from KG price with comma as decimalpoint

ROUND(MULTIPLY(DIVIDE(DECIMAL('[Preis]'),100),10),'.',',')


price formats comparsion to set 0 or 1 for Designer Dependencys 

IF(INTEGER('[Price]') < INTEGER('[ListPrice]'),'0','1')


if field "RabattProz" > 0 then Field with additional text otherwise simple a other text..

IF(DECIMAL('[RabattProz]') > 0,'[RabattProz]% sparen','easyPreis spart')


When field "Listenpreis" greater 0 than show this field otherwise empty. for Designer dependency steering

IF(DECIMAL('[ListenPreis]') > 0,'[ListenPreis]','')


just to for steering the visibility of a designer element

IF(DECIMAL([PackungsMenge])=999,'0',

IF(DECIMAL([GrdPreisCalc])=999,'0',

'1'))




samples from other installations

Telia DK

IF(ENDSWITH(UPPER('[electronic_template_name]'),'CAMPAIGN'),'[electronic_template_name]','HANDSET')


Lindback Bergen

IF(STARTSWITH('[Lagringsgrad]','Drikkeklar nå, men kan også lagres'),'Y',IF(STARTSWITH('[Lagringsgrad]','Drikkeklar, ikke egnet for lagring'),'X', IF(STARTSWITH('[Lagringsgrad]','Kan drikkes nå, blir bedre ved lagring'),'Z','[Lagringsgrad]')))

IF(STARTSWITH('[Syre]','Ukjent'),'','[Syre]')

IF(STARTSWITH('[Sukker]','Ukjent'),'','[Sukker]')

IF(STARTSWITH('[Underdistrikt]','Øvrige'),'','[Underdistrikt]')

IF(STARTSWITH('[Distrikt]','Øvrige'),'','[Distrikt]')

UPPER('[Land]')

IF(STARTSWITH('[Passertil03]',' Aperitiff/avec'),'A',IF(STARTSWITH('[Passertil03]','Skalldyr'),'B', IF(STARTSWITH('[Passertil03]','Fisk'),'C', IF(STARTSWITH('[Passertil03]','Lyst'),'D', IF(STARTSWITH('[Passertil03]','Storfe'),'E', IF(STARTSWITH('[Passertil03]','Lam'),'F', IF(STARTSWITH('[Passertil03]','Småvilt'),'G', IF(STARTSWITH('[Passertil03]','Storvilt'),'H', IF(STARTSWITH('[Passertil03]','Ost'),'L', IF(STARTSWITH('[Passertil03]','Dessert'),'N', IF(STARTSWITH('[Passertil03]','Svinekjøtt'),'Q', IF(STARTSWITH('[Passertil03]','Grønnsaker'),'R','[Passertil03]'))))))))))))

IF(STARTSWITH('[Passertil02]',' Aperitiff/avec'),'A',IF(STARTSWITH('[Passertil02]','Skalldyr'),'B', IF(STARTSWITH('[Passertil02]','Fisk'),'C', IF(STARTSWITH('[Passertil02]','Lyst'),'D', IF(STARTSWITH('[Passertil02]','Storfe'),'E', IF(STARTSWITH('[Passertil02]','Lam'),'F', IF(STARTSWITH('[Passertil02]','Småvilt'),'G', IF(STARTSWITH('[Passertil02]','Storvilt'),'H', IF(STARTSWITH('[Passertil02]','Ost'),'L', IF(STARTSWITH('[Passertil02]','Dessert'),'N', IF(STARTSWITH('[Passertil02]','Svinekjøtt'),'Q', IF(STARTSWITH('[Passertil02]','Grønnsaker'),'R','[Passertil02]'))))))))))))

IF(STARTSWITH('[Passertil01]',' Aperitiff/avec'),'A',IF(STARTSWITH('[Passertil01]','Skalldyr'),'B', IF(STARTSWITH('[Passertil01]','Fisk'),'C', IF(STARTSWITH('[Passertil01]','Lyst'),'D', IF(STARTSWITH('[Passertil01]','Storfe'),'E', IF(STARTSWITH('[Passertil01]','Lam'),'F', IF(STARTSWITH('[Passertil01]','Småvilt'),'G', IF(STARTSWITH('[Passertil01]','Storvilt'),'H', IF(STARTSWITH('[Passertil01]','Ost'),'L', IF(STARTSWITH('[Passertil01]','Dessert'),'N', IF(STARTSWITH('[Passertil01]','Svinekjøtt'),'Q', IF(STARTSWITH('[Passertil01]','Grønnsaker'),'R','[Passertil01]'))))))))))))

ROUND(MULTIPLY(DECIMAL([Volum]),100),0)


Demo Mats Olsson

ROUND(SUBTRACT([Price],[CampaignPrice]),2)


Demo ROOM

IF(ISNOTEMPTY('[DiscountPrice]'),'0','1')


Globus Fachmärkte

IF(STARTSWITH('[AKTIONSKZ]','U'),'Aktion',IF(STARTSWITH('[AKTIONSKZ]','R'),'Aktion','Standard'))


HiBike

IF(DECIMAL('[UVP]') = DECIMAL('[CurrentPrice]'),'0','1')

IF(DECIMAL('[UVP]') = DECIMAL('[MinPrice]'),'0','1')

IF(DECIMAL('[UVP]') = DECIMAL('[PromoPreis]'),'0','1')


If Itemid starts with G_ the EAN get a G_ in front of the field else the EAN is untouched in the field

IF(STARTSWITH('[Itemnumber]','G_'),'G_[EAN]','[EAN]')



FotoProfi Ersparnisals Wert into field Ersparnis with comma as decimal point and 2 decimals


REPLACE(ROUND(SUBTRACT(DECIMAL([UPE]),DECIMAL([Verkaufspreis])),2),'.',',')

FotoProfi if field Ersparnis positive set 1 to steering Design

IF(DECIMAL('[Ersparnis]')<=0,'0','1')