You have the following dataset. When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table. What should you do?
A.
Change the default number format of the Sales field.
B.
Create a calculated field that uses a formula of '$' + str (Round([Sales],2)) + 'K'.
C.
Create a calculated field that uses a formula of' '$' + str (([Sales]/1000)).
D.
Change the data type of the Sales field to String.
B will not work because it rounds to only 2 digits, but some of the values are 3 digits.
C will not work because it will not append the 'K'.
D will not work because converting to string would only convert the numeric data type into a string with the same value.
A is the correct answer.
A is correct. we can achieve it through calculated field as well but it will add new measure/dimension
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MonBouj
6 months agoJUT_TC
1 year, 2 months agoZabba
1 year, 3 months agoVedjha
1 year, 3 months ago