Create a new column named 'Total' that calculates the summation of the item and how much sales tax is due on the item (Note: Tax is displayed in PERCENT!)
Create a new field called 'Full Name'. In the new field, concatenate 'First Name' and 'Last Name' together
Uppercase 'Customer Segment'
2
100
Corporate
No
JEAN
SMITH
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
Corporate
No
JULIA
CARRERA
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
Home Office
No
LINDA
TREVINO
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
Home Office
No
H
MACK
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
Home Office
No
MARISSA
LATTA
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
Home Office
No
PHYLLIS
WALKER
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
Home Office
No
VIVIAN
GAULDEN
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
Home Office
No
PAMELA
WRIGHT
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
Home Office
No
MARIA
GONZALEZ
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
Home Office
No
WANDA
MAYBERRY
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Titlecase 'First Name' and 'Last Name'
2
100
CORPORATE
No
JEAN
SMITH
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
JULIA
CARRERA
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
LINDA
TREVINO
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
MACK
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
MARISSA
LATTA
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
PHYLLIS
WALKER
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
VIVIAN
GAULDEN
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
PAMELA
WRIGHT
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
MARIA
GONZALEZ
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
WANDA
MAYBERRY
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Using the countwords() and getword() function, create a new column named 'Suffix' that contains the address suffix (DR, WAY, ST)
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Using the countwords()) function, create a new column named 'Count' that contains the number of words in the 'Address' field
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Some zip codes have 9+ digits - use the left() function to overwrite the 'Zip' Field with just the first 5 characters of the zip code
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
We want to rename some of the customer segments in our data.
Using a conditional statement, set 'CORPORATE' to 'CORE', 'HOME OFFICE' to 'HOME', and anything else to 'OTHER'
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
SUPPLY
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
SUPPLY
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
We want to create a new field called 'Target Area'. Using the IIF() function, set any customer in the city of Denver to 'In Target'. All other customers should be 'Out of Target'
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
SUPPLY
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
SUPPLY
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
1512.00
2.9
3344.22
2.9
5943.01
2.9
2343.12
2.9
58433.81
2.9
Create a new column that says 'Formatted Total'. Use the tostring() function to add commas, set the number to 2 decimal places, and concatenate a '$' before the values. See the help files for the secret settings!
1512
2.9
1555.85
3344.22
2.9
3441.20
5943.01
2.9
6115.36
2343.12
2.9
2411.07
58433.81
2.9
60128.39
Target Result
2
100
CORPORATE
No
JEAN
SMITH
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
JULIA
CARRERA
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
LINDA
TREVINO
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
MACK
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
MARISSA
LATTA
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
PHYLLIS
WALKER
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
VIVIAN
GAULDEN
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
PAMELA
WRIGHT
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
MARIA
GONZALEZ
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
WANDA
MAYBERRY
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Target Result
Target Result
Target Result
Target Result
Target Result
Target Result
Target Result
Target Result
Target Result
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
Jean Smith
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
Julia Carrera
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
Linda Trevino
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
H Mack
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
Marissa Latta
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
Phyllis Walker
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
Vivian Gaulden
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
Pamela Wright
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
Maria Gonzalez
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Wanda Mayberry
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
ST
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
WAY
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
ST
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
ST
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
CIR
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
ST
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
WAY
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
AVE
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
ST
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
ST
2
100
CORE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
OTHER
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
OTHER
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
1512
2.9
1555.85
3344.22
2.9
3441.20
5943.01
2.9
6115.36
2343.12
2.9
2411.07
58433.81
2.9
60128.39
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
4
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
4
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
3
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
3
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
4
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
4
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
3
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
4
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
3
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
3
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
In Target
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
In Target
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
In Target
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
In Target
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
Out of Target
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
Out of Target
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
In Target
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
In Target
11
106
SUPPLY
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
In Target
12
108
SUPPLY
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
In Target
1512
2.9
1555.85
$1,555.85
3344.22
2.9
3441.2
$3,441.20
5943.01
2.9
6115.36
$6,115.36
2343.12
2.9
2411.07
$2,411.07
58433.81
2.9
60128.39
$60,128.39
Formula Tool Examples
Click the triangle on the right to see the solutions.
Use the Formula tool to achieve the target output.
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_8a9746a3c2094cd3aad5ee4353a8491d_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_2d9c6ef9a18d4744921e5f9b81f867a3_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_0c8a0294ea4b4f83ad334d13318ef371_.yxdb
Single
Profile
Customer Segment = IF [Customer Segment] == 'CORPORATE' THEN 'CORE'
ELSEIF [Cust...
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_089eafcb8d40444aa78eb8ca16405886_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_72c803fd0cde47c4aa25915dd45bb5b6_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_24319be765814bc3a188dfe2975ebf71_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_8fa2b13f94d741a8b144781e59617e5d_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_6fec11dd2cbd4addb0e982c1451107d1_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_b51a5934e7b749449393640dc26d627a_.yxdb
Single
Profile
C:\Users\adluayon\AppData\Local\Temp\Engine_4236_bfa1925ebb8c4a63b5d42902b48271a6_\Engine_8644_6acb013b2b944050aa85505a2c2bbe4c_.yxdb
Single
Profile
Solutions
Create a new column named 'Total' that calculates the summation of the item and how much sales tax is due on the item (Note: Tax is displayed in PERCENT!)
Create a new field called 'Full Name'. In the new field, concatenate 'First Name' and 'Last Name' together
Uppercase 'Customer Segment'
2
100
Corporate
No
JEAN
SMITH
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
Corporate
No
JULIA
CARRERA
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
Home Office
No
LINDA
TREVINO
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
Home Office
No
H
MACK
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
Home Office
No
MARISSA
LATTA
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
Home Office
No
PHYLLIS
WALKER
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
Home Office
No
VIVIAN
GAULDEN
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
Home Office
No
PAMELA
WRIGHT
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
Home Office
No
MARIA
GONZALEZ
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
Home Office
No
WANDA
MAYBERRY
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Titlecase 'First Name' and 'Last Name'
2
100
CORPORATE
No
JEAN
SMITH
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
JULIA
CARRERA
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
LINDA
TREVINO
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
MACK
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
MARISSA
LATTA
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
PHYLLIS
WALKER
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
VIVIAN
GAULDEN
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
PAMELA
WRIGHT
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
MARIA
GONZALEZ
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
WANDA
MAYBERRY
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Using the countwords() and getword() function, create a new column named 'Suffix' that contains the address suffix (DR, WAY, ST)
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Using the countwords()) function, create a new column named 'Count' that contains the number of words in the 'Address' field
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
Some zip codes have 9+ digits - use the left() function to overwrite the 'Zip' Field with just the first 5 characters of the zip code
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
We want to rename some of the customer segments in our data.
Using a conditional statement, set 'CORPORATE' to 'CORE', 'HOME OFFICE' to 'HOME', and anything else to 'OTHER'
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
SUPPLY
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
SUPPLY
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
Customer Segment = IF [Customer Segment]='CORPORATE' THEN 'CORE'
ELSEIF [Custome...
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
HOME OFFICE
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
HOME OFFICE
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214
39.746908566321
-105.082754280269
We want to create a new field called 'Target Area'. Using the IIF() function, set any customer in the city of Denver to 'In Target'. All other customers should be 'Out of Target'
2
100
CORPORATE
No
Jean
Smith
376 S JASMINE ST
DENVER
CO
80224-0111
39.7097342857143
-104.918581741593
3
100
CORPORATE
No
Julia
Carrera
846 S UMATILLA WAY
DENVER
CO
80223
39.7009275356545
-105.012175941854
5
100
HOME OFFICE
No
Linda
Trevino
5360 ZUNI ST
DENVER
CO
80221
39.7939240392764
-105.015644744517
6
106
HOME OFFICE
No
H
Mack
1599 WILLIAMS ST
DENVER
CO
80218-3234
39.74162
-104.966148340861
7
105
HOME OFFICE
No
Marissa
Latta
12066 E LAKE CIR
ENGLEWOOD
CO
80111
39.6064016372081
-104.849237400256
8
101
HOME OFFICE
No
Phyllis
Walker
7225 S GAYLORD ST
LITTLETON
CO
80122
39.5871251428571
-104.962487942571
9
105
HOME OFFICE
No
Vivian
Gaulden
4497 CORNISH WAY
DENVER
CO
80239-1211
39.778242949727
-104.829779947848
10
100
HOME OFFICE
No
Pamela
Wright
2316 E 5TH AVE
DENVER
CO
80206
39.7239928674084
-104.959232244898
11
106
SUPPLY
No
Maria
Gonzalez
3883 QUITMAN ST
DENVER
CO
80212
39.7707029975632
-105.040646477717
12
108
SUPPLY
No
Wanda
Mayberry
1965 YUKON ST
DENVER
CO
80214-9921
39.746908566321
-105.082754280269
1512.00
2.9
3344.22
2.9
5943.01
2.9
2343.12
2.9
58433.81
2.9
Create a new column that says 'Formatted Total'. Use the tostring() function to add commas, set the number to 2 decimal places, and concatenate a '$' before the values. See the help files for the secret settings!
1512
2.9
1555.85
3344.22
2.9
3441.20
5943.01
2.9
6115.36
2343.12
2.9
2411.07
58433.81
2.9
60128.39
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.
Horizontal
formula_try_it