Skip to Content
0
Former Member
May 08, 2007 at 10:15 PM

CR XI: nested SELECT statements?

11 Views

Post Author: dmcheng

CA Forum: Formula

Hi. I'm using CR XI R2. Is it possible to build nested SELECT statements? See code below. The first Household Category group evaluates correclty. However, in Household Category 2 and later, the IncomeRangeColumns are not always set correctly - sometimes it is blank when there is a an Income, and other times it is a value when there is no Income. NumberVar IncomeRangeColumn;Select {@HouseholdCategory} Case 1: (Select {@Household Income} Case Is <= 19600: IncomeRangeColumn := 1 Case 19601 to 35760: IncomeRangeColumn := 2) Case 2: (Select {@Household Income} Case Is <= 26400: IncomeRangeColumn := 1 Case 26401 to 40868: IncomeRangeColumn := 2) Case 3: (Select {@Household Income} Case Is <= 33200: IncomeRangeColumn := 1 Case 33201 to 45977: IncomeRangeColumn := 2)