kzupancic of ACE-CRM
10/31/2018 - 1:29 PM

Contact Age Range - Option 2

Drilling in more on age ranges & in line with how this is reporting in ACE Reputation Management

Age Range - 2
content_copyfile_download
IF [Age]>= 65 THEN '65+ years'
ELSEIF [Age]>= 55 AND  [Age] <= 64 THEN '55-64 years'
ELSEIF [Age]>= 45 AND  [Age] <= 54 THEN '45-54 years'
ELSEIF [Age]>= 35 AND  [Age] <= 44 THEN '35-44 years'
ELSEIF [Age]>= 25 AND  [Age] <= 34 THEN '25-34 years'
ELSEIF [Age]>= 1 AND  [Age] <= 24 THEN 'under 25 years'
ELSE 'NA' END