IBM
P2020-300 · Question #42
Click the Exhibit button. In the exhibit, you are creating a calculation to output only the results for the last month of anyquarter from the calculation "QTD Payment". The"Time"table is joined…
The correct answer is B. "Time (Month)".Ending = "Time (Quarter)".Ending. See the full explanation below for the reasoning.
Question
Click the Exhibit button. In the exhibit, you are creating a calculation to output only the results for the last month of anyquarter from the calculation "QTD Payment". The"Time"table is joined twice at month and quarter level. Which additional restriction is required on the second join to the “Time” table at the quarter level?
Options
- A"Time (Month)".Starting = "Time (Quarter)".Starting
- B"Time (Month)".Ending = "Time (Quarter)".Ending
- C"Time (Month)".Name = "Time (Quarter)".Name
- D"Time (Month)".Parent = "Time (Quarter)".Name
How the community answered
(23 responses)- A4% (1)
- B78% (18)
- C13% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.