if then else

This construct is the template for an if...then...else statement. This construct appears in the Top 10 Retailers for 2005 sample report in the GO Data Warehouse (analysis) package.

IF ([Country] = 'Canada') THEN ([List Price] * 0.60) ELSE ([List 
Price])