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! Go to Solution.
Please try
<<START:[RELATED_ORDERS]>>
<<ORDERDETAILID>>
<<ORDERID>>
<<[PRODUCT CODE]>>
<<IF(ISBLANK([PRODUCTCODE].[FRENCH NAME]), [Product Name], [PRODUCTCODE].[FRENCH NAME]) >>
<<[QTY]>>
<<END>>
Please try
<<START:[RELATED_ORDERS]>>
<<ORDERDETAILID>>
<<ORDERID>>
<<[PRODUCT CODE]>>
<<IF(ISBLANK([PRODUCTCODE].[FRENCH NAME]), [Product Name], [PRODUCTCODE].[FRENCH NAME]) >>
<<[QTY]>>
<<END>>
User | Count |
---|---|
16 | |
11 | |
9 | |
8 | |
4 |