SAP
C_BOWI_40 · Question #63
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and
Sign in or unlock C_BOWI_40 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Using Formulas and Variables
Question
You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?
Options
- ANoFilter()
- BNoRank()
- CAverageAll()
- DIgnoreFilter()
Unlock C_BOWI_40 to see the answer
You've previewed enough free C_BOWI_40 questions. Unlock C_BOWI_40 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#NoFilter()#ranking#aggregate functions#calculation context