03-07-2017 01:18 PM
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?
03-08-2017 03:36 AM
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?
03-08-2017 05:26 PM
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