'''IF(("Price" > 1000) || ("Profit" >= 50);75;55)''' - If ''Price'' is greater than ''1000'' '''OR''' ''Profit'' is greater than or equal to ''50'' returns ''75'' if not ''55''
'''IF(("Price" > 1000) || ("Profit" >= 50);75;55)''' - If ''Price'' is greater than ''1000'' '''OR''' ''Profit'' is greater than or equal to ''50'' returns ''75'' if not ''55''
+
'''IF(("City" != "#null") || ("Product" != 'Lasagna');1;0)''' - If ''City'' is non-null '''OR''' ''Product'' is different from ''Lasagna'' returns ''1'' if it does not return ''0''
Latest revision as of 14:25, 19 November 2020
Syntax:
<expression> || <expression>
Examples:
IF(("Price" > 1000) || ("Profit" >= 50);75;55) - If Price is greater than 1000ORProfit is greater than or equal to 50 returns 75 if not 55IF(("City" != "#null") || ("Product" != 'Lasagna');1;0) - If City is non-null ORProduct is different from Lasagna returns 1 if it does not return 0