ExamGecko
Question list
Search
Search

List of questions

Search

Related questions

Question 89 - Desktop Certified Associate discussion

Report
Export

Which of the following are valid calculations?

A.
MAX(SUM(Profit), (Sales))
Answers
A.
MAX(SUM(Profit), (Sales))
B.
SUM([Profit]) * SUM([Quantity])
Answers
B.
SUM([Profit]) * SUM([Quantity])
C.
SUM([Profit]) * 1000
Answers
C.
SUM([Profit]) * 1000
D.
SUM([Profit]) * [Quantity]
Answers
D.
SUM([Profit]) * [Quantity]
Suggested answer: B, C

Explanation:

You cannot mix the aggregated and non-aggregated calculations.

MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.

SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.

You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.

SUM([Profit]) * SUM([Quantity]) - Both are aggregated

asked 23/09/2024
mostafa khalaf
53 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first