Main
1
824
Main
2
1145
Main
3
1354
Main
4
916
Main
5
1120
Main
6
635
Main
7
1056
Main
8
824
Main
9
616
Main
10
679
Priority - Ascending
Item - Ascending
[Item] = 6
Simple
=
Item
True
fixed
2019-08-10 14:16:04
0
6
2019-08-10 14:16:04
2019-08-10 14:16:04
[Item] = 6
New_Count
New_Count
Int32
4
Nearest
IF [RecordID]==1
THEN [Count]-[Required]
ELSE [Row-1:New_Count] -[Required]
ENDIF
IF [RecordID]==1
THEN [Count]-[Required]
ELSE [Row-1:New_Co...
RecordID
1
Int32
6
0
A
26
Houston
TX
1
47
A
26
Houston
TX
2
29
A
26
Houston
TX
3
50
A
26
Houston
TX
4
12
A
26
Houston
TX
5
19
A
26
Houston
TX
6
72
A
26
Houston
TX
7
71
A
26
Houston
TX
8
2
A
26
Houston
TX
10
40
B
4
Birmingham
AL
2
46
B
4
Birmingham
AL
3
36
B
4
Birmingham
AL
4
7
B
4
Birmingham
AL
5
48
B
4
Birmingham
AL
6
71
B
4
Birmingham
AL
7
19
B
4
Birmingham
AL
10
4
C
25
Seattle
WA
1
34
C
25
Seattle
WA
2
52
C
25
Seattle
WA
3
66
C
25
Seattle
WA
4
17
C
25
Seattle
WA
6
3
C
25
Seattle
WA
7
57
C
25
Seattle
WA
8
77
C
25
Seattle
WA
10
13
D
3
Detroit
MI
2
1
D
3
Detroit
MI
3
76
D
3
Detroit
MI
4
46
D
3
Detroit
MI
6
21
D
3
Detroit
MI
7
40
D
3
Detroit
MI
10
41
E
5
Nashville
TN
1
44
E
5
Nashville
TN
2
14
E
5
Nashville
TN
5
75
E
5
Nashville
TN
6
32
E
5
Nashville
TN
7
14
E
5
Nashville
TN
8
76
E
5
Nashville
TN
10
42
F
2
Chicago
IL
1
71
F
2
Chicago
IL
2
28
F
2
Chicago
IL
3
46
F
2
Chicago
IL
4
54
F
2
Chicago
IL
5
9
F
2
Chicago
IL
6
52
F
2
Chicago
IL
7
43
F
2
Chicago
IL
8
33
F
2
Chicago
IL
9
59
F
2
Chicago
IL
10
16
G
24
Lansing
IA
1
60
G
24
Lansing
IA
2
2
G
24
Lansing
IA
3
51
G
24
Lansing
IA
4
66
G
24
Lansing
IA
5
47
G
24
Lansing
IA
6
28
G
24
Lansing
IA
7
66
G
24
Lansing
IA
9
30
G
24
Lansing
IA
10
55
H
1
Fayetteville
NC
1
11
H
1
Fayetteville
NC
2
69
H
1
Fayetteville
NC
3
5
H
1
Fayetteville
NC
4
41
H
1
Fayetteville
NC
5
54
H
1
Fayetteville
NC
7
28
H
1
Fayetteville
NC
8
57
H
1
Fayetteville
NC
9
17
H
1
Fayetteville
NC
10
36
I
23
Miami
FL
2
6
I
23
Miami
FL
4
73
I
23
Miami
FL
5
43
I
23
Miami
FL
6
3
I
23
Miami
FL
7
70
I
23
Miami
FL
8
70
I
23
Miami
FL
9
16
I
23
Miami
FL
10
17
J
22
Tampa
FL
1
71
J
22
Tampa
FL
2
35
J
22
Tampa
FL
4
5
J
22
Tampa
FL
5
79
J
22
Tampa
FL
6
9
J
22
Tampa
FL
7
38
J
22
Tampa
FL
9
55
J
22
Tampa
FL
10
72
K
21
Charleston
SC
1
44
K
21
Charleston
SC
2
13
K
21
Charleston
SC
3
63
K
21
Charleston
SC
4
73
K
21
Charleston
SC
6
62
K
21
Charleston
SC
7
61
K
21
Charleston
SC
8
20
K
21
Charleston
SC
10
25
L
6
Los Angeles
CA
1
26
L
6
Los Angeles
CA
3
10
L
6
Los Angeles
CA
4
35
L
6
Los Angeles
CA
5
62
L
6
Los Angeles
CA
6
16
L
6
Los Angeles
CA
7
73
L
6
Los Angeles
CA
8
35
L
6
Los Angeles
CA
9
78
L
6
Los Angeles
CA
10
33
M
20
Sacramento
CA
2
12
M
20
Sacramento
CA
3
23
M
20
Sacramento
CA
4
55
M
20
Sacramento
CA
5
46
M
20
Sacramento
CA
6
9
M
20
Sacramento
CA
7
4
M
20
Sacramento
CA
8
8
M
20
Sacramento
CA
9
76
M
20
Sacramento
CA
10
60
N
7
Tucson
AZ
2
9
N
7
Tucson
AZ
4
29
N
7
Tucson
AZ
5
12
N
7
Tucson
AZ
6
4
N
7
Tucson
AZ
7
36
N
7
Tucson
AZ
8
3
N
7
Tucson
AZ
10
8
O
8
Dallas
TX
1
15
O
8
Dallas
TX
2
35
O
8
Dallas
TX
5
30
O
8
Dallas
TX
6
43
O
8
Dallas
TX
8
78
O
8
Dallas
TX
9
48
O
8
Dallas
TX
10
64
P
19
Austin
TX
2
60
P
19
Austin
TX
3
33
P
19
Austin
TX
4
5
P
19
Austin
TX
5
9
P
19
Austin
TX
6
27
P
19
Austin
TX
7
62
P
19
Austin
TX
8
71
P
19
Austin
TX
9
30
P
19
Austin
TX
10
50
Q
9
Tulsa
OK
2
22
Q
9
Tulsa
OK
3
32
Q
9
Tulsa
OK
4
11
Q
9
Tulsa
OK
5
4
Q
9
Tulsa
OK
6
46
Q
9
Tulsa
OK
7
69
Q
9
Tulsa
OK
8
46
Q
9
Tulsa
OK
9
12
Q
9
Tulsa
OK
10
53
R
16
New York
NY
2
76
R
16
New York
NY
3
15
R
16
New York
NY
4
13
R
16
New York
NY
5
69
R
16
New York
NY
6
41
R
16
New York
NY
7
49
R
16
New York
NY
8
50
R
16
New York
NY
10
9
S
10
Baltimore
MD
1
23
S
10
Baltimore
MD
2
9
S
10
Baltimore
MD
4
27
S
10
Baltimore
MD
5
31
S
10
Baltimore
MD
6
31
S
10
Baltimore
MD
7
17
S
10
Baltimore
MD
8
69
S
10
Baltimore
MD
9
53
S
10
Baltimore
MD
10
21
T
15
Portland
OR
1
19
T
15
Portland
OR
2
66
T
15
Portland
OR
3
76
T
15
Portland
OR
4
56
T
15
Portland
OR
5
78
T
15
Portland
OR
6
53
T
15
Portland
OR
7
62
T
15
Portland
OR
8
2
T
15
Portland
OR
9
12
U
11
Philadelphia
PA
1
71
U
11
Philadelphia
PA
2
54
U
11
Philadelphia
PA
4
3
U
11
Philadelphia
PA
5
54
U
11
Philadelphia
PA
6
3
U
11
Philadelphia
PA
7
48
U
11
Philadelphia
PA
8
6
V
12
Boston
MA
1
65
V
12
Boston
MA
2
30
V
12
Boston
MA
3
4
V
12
Boston
MA
4
12
V
12
Boston
MA
5
50
V
12
Boston
MA
7
37
V
12
Boston
MA
8
10
V
12
Boston
MA
9
76
W
13
Helena
MT
1
76
W
13
Helena
MT
2
68
W
13
Helena
MT
3
10
W
13
Helena
MT
4
48
W
13
Helena
MT
5
65
W
13
Helena
MT
7
60
W
13
Helena
MT
8
15
W
13
Helena
MT
9
31
X
14
Denver
CO
1
8
X
14
Denver
CO
2
49
X
14
Denver
CO
3
57
X
14
Denver
CO
4
23
X
14
Denver
CO
5
25
X
14
Denver
CO
7
39
X
14
Denver
CO
8
45
X
14
Denver
CO
9
68
Y
18
Milwaukee
WI
1
6
Y
18
Milwaukee
WI
2
47
Y
18
Milwaukee
WI
4
1
Y
18
Milwaukee
WI
5
26
Y
18
Milwaukee
WI
6
64
Y
18
Milwaukee
WI
7
33
Y
18
Milwaukee
WI
8
41
Y
18
Milwaukee
WI
9
33
Y
18
Milwaukee
WI
10
7
Z
17
Las Vegas
NV
1
60
Z
17
Las Vegas
NV
2
25
Z
17
Las Vegas
NV
3
39
Z
17
Las Vegas
NV
4
45
Z
17
Las Vegas
NV
5
75
Z
17
Las Vegas
NV
6
18
Z
17
Las Vegas
NV
7
18
Z
17
Las Vegas
NV
8
25
Z
17
Las Vegas
NV
9
2
Z
17
Las Vegas
NV
10
10
RecordID
Assigned
Int32
4
Nearest
IF [Row-1:New_Count] > [Required]
THEN [Required]
ELSE 0
ENDIF
IF [Row-1:New_Count] > [Required]
THEN [Required]
ELSE 0
E...
Assigned
New Field
Int32
4
Empty
IF [New_Count]<0 && [Row-1:New_Count]>0
THEN [Row-1:New_Count]
ELSE [Assigned]
ENDIF
IF [New_Count]<0 && [Row-1:New_Count]>0
THEN [Row-1:New_Count...
Horizontal
RL_Challenge_14Macro