Start expressions with condition

Hello everyone,
I wonder if it is possible to add a condition to the expression below. if the FRENCH NAME is not written in the product table I don't want an expression that came with a blank row, is it possible to pull the PRODUCT NAME on condition? 

<<START:[RELATED_ORDERS]>>
<<ORDERDETAILID>>
<<ORDERID>>
<<[PRODUCT CODE]>>
<<[PRODUCTCODE].[FRENCH NAME]>>  "if FRENCH NAME is blank" than add PRODUCT NAME"
<<[QTY]>>
<<END>>

Thanks in advance

Solved Solved
0 1 66
1 ACCEPTED SOLUTION

Please try 

<<START:[RELATED_ORDERS]>>
<<ORDERDETAILID>>
<<ORDERID>>
<<[PRODUCT CODE]>>
<<IF(ISBLANK([PRODUCTCODE].[FRENCH NAME]), [Product Name], [PRODUCTCODE].[FRENCH NAME]) >>  
<<[QTY]>>
<<END>>

View solution in original post

1 REPLY 1

Please try 

<<START:[RELATED_ORDERS]>>
<<ORDERDETAILID>>
<<ORDERID>>
<<[PRODUCT CODE]>>
<<IF(ISBLANK([PRODUCTCODE].[FRENCH NAME]), [Product Name], [PRODUCTCODE].[FRENCH NAME]) >>  
<<[QTY]>>
<<END>>

Top Labels in this Space