Reply
Frequent Visitor
Posts: 2
Registered: ‎03-07-2017

Lab 2 Excercise 1: Don't have Country Name column in Sales Table

Hello there,

 

I were trying to do this...

 

3. Edit the Sales table in the Data view

4. Add a new column named  CountryZip by concatenating the value from the Country Name column, a comma and a space character, and the value from the Zip column. (Hint: the calculated column formula look as follows: CountryZip = Sales[Country Name] & ", " & Sales[Zip])

 

When I realized that there is no Country Name column in Sales table, I loaded the correct file called Lab 2 - Starting.

 

What is the problem?

 

Thank You!

Member
Posts: 93
Registered: ‎03-10-2016

Re: Lab 2 Excercise 1: Don't have Country Name column in Sales Table

I download and open the Lab2 -Starting file, the "Country Name" is display for me. The screenshot result as below:

Lab2_ex1_Country Name.png

Frequent Visitor
Posts: 2
Registered: ‎03-07-2017

Re: Lab 2 Excercise 1: Don't have Country Name column in Sales Table

Don't know what was the problem but I loaded the file again and it worked fine.

 

By the way, I have lost 2 points because of a misunderstanding, one answer was with negative (-) sign but we had to input answer without it. I didn't know what does it mean by "absolute" answer.

 

Why not simply taking answer as it is?

Member
Posts: 93
Registered: ‎03-10-2016

Re: Lab 2 Excercise 1: Don't have Country Name column in Sales Table

Due to we get a negative value by the formula, but we need to input positive value in text box, so the question give everybody a tip, you need use "absolute value". For example, if you get a value "-4", the absolute value is "4". Hope this is helpful for you