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?
A. • count(BookinglD)
• [TolalCost]
• [Totalincomel
• sum(income|-sum[TotalCost]
• [TotalMargin]-sum(Cost)/sumTotal(lncome)*100
B. • count(dislinct BookinglD)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100
C. • count(dislinct BookinglD)
• [TolalCost]
• [Totalincome]
• [Totalincome|-[TotalCost]
• [TotalMargin]/[Totalllncome}*100
D. • count(distinct BookinglO)
• [TolalCost]
• [Totalincomel
• ITotalincome|-[TotalCost]
• [TotalMargin]/{Totalllncome}*100