A company that manages several tennis clubs uses an app mat includes three master measures TotalCost, Totallncome, and TotalMargin A business analyst needs to create a new table that utilizes master items and meets the following requirements:
•Number of bookings that users make
•Cost associated with booking (including electricity and indirect costs)
•Income obtained and profit originated m each booking
•Sales margin: percentage of margin over income
•Detail by tennis clubs
Which optimal expressions should the business analyst use?
• count(BookinglD)
• [TolalCost]
• [Totalincomel
• sum(income|-sum[TotalCost]
• [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
• count(dislinct BookinglD)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100
• count(dislinct BookinglD)
• [TolalCost]
• [Totalincome]
• [Totalincome|-[TotalCost]
• [TotalMargin]/[Totalllncome}*100
• count(distinct BookinglO)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100
Reveal Solution Next Question