Alerters and Grouping

1

• Alerters and Grouping

Module 8
2
Alerters

• Use Alerters to draw attention to items of data
  in a block.
• Alerters can highlight data in two ways
• By changing the format of values
• By displaying a comment next to or in place of
  certain results

3
Creating Alerters
2
1
3
4
Creating Alerters (cont.)
4
8
High Grades
6
Type the name of your alerter High Grades
5
Type the 13 or select from the list of values
7
5
Creating Alerters (cont.)
9
10
12
11
13
Be sure to select the Font tab.
6
Creating Alerters (cont.)
7
Text Alerters

• Similar to changing the font, you can change
  the text when certain conditions are met.

8
Using Text Alerters
1
2
3
4
9
Using Text Alerters (cont)
10
Grouping Data

• You can create new variables by grouping the
  values of existing variables or objects.
• Grouping Aggregates quantities

11
Creating a Data Grouping

• Annuitant Indicator returns four values

Re-employed Re-employed Retired
Retired Annuitant-CS Annuitant-FE
Enlisted Officer
By grouping Re-employed annuitants into one
group (Re-employed), and Retired Annuitants into
another value (Retired), you create a variable.
12
Creating a Data Grouping (cont)
3
2
1
Hold down the CTL key while selecting Reempl
Ann-FE.
5
Re-employed
4
Type the name of your group Re-employed
13
Creating a Data Grouping (cont)
Repeat the same process to combine Ret Enlisted
and Ret Officer into Retired.
14
Creating a Data Grouping (cont)
15
EXERCISE TIME