Question: Which is the correct formula for create a new calculated field: Sales per Customer, which refers to the average sales value for each unique customer.

  1. Which is the correct formula for create a new calculated field: Sales per Customer, which refers to the average sales value for each unique customer.

    a.

    Sum([Profit])/ Sum([Sales])
    b.

    Sum([Sales])/Count([Customer_ID])
    c.

    Sum([Profit])/CountD([Order_ID])
    d.

    Sum([Sales])/CountD([Customer_ID])

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Which is the correct formula for create a new calculated field: Sales per Customer, which refers to the average sales value for each unique customer. O a. Sum([Profit])/ Sum([Sales]) O b....

Q:

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

Q:

1) In cell D4, enter a formula that calculates customer tenure, in years, using absolute and structured references. The formula should calculate tenure based on subtracting the value in the First...

Q:

Please help me, I have never used Tableau before. If you give me your email I could send the Excel file to you also. I am really having trouble with the Verify Data section. Step 1 - Load and Verify...

Q:

PROJECT STEPS 1. Go to the CustomerList worksheet and complete the following actions: a. Apply a conditional formatting rule to the range A4:A32 that formats any duplicate values with Yellow Fill...

Q:

Using disclosures made in the 2015 Woolworths Annual Report, 2015 Woolworths CSR Report or current website for Woolworths (http://www.woolworthslimited.com.au) identify and provide 4 examples where...

Q:

Choose the correct answer in the following: 1. All of the following are components of an information system, except: Users Data collection devices Data sharing devices All of the above are components...

Q:

I did the first half of this, can I recieve help with the second half of this? This is the beginning of the first part that was not provided. I'm providing it now. INPUT SECTION SALES 4th Quarter...

Q:

I did the first part of this, can I receive help on the second part of it? I have all the information needed included. INPUT SECTION SALES 4th Quarter 2020 1st Quarter 2nd Quarter 2021 48,100 3rd 4th...

Q:

I did the first part of this, can I recieve help with the second part of it. I provided all the needed information to complete. I've had previously posted this and a chegg member helped me with 4...

Q:

6. The dimensions of a box are 3 cm x 5 cm x 7 cm. The width, length, and height of the box must be increased by the same amount x in order for the box to have a volume of 693 cm cubed. Determine the...

Q:

Did Matlin commit a misrepresentation on his policy application? Provident Insurance, Inc., issued an insurance policy to a company providing an employee, Steve Matlin, with disability insurance....

Q:

Pleaee help do journal entry Feb 1 Invest in company $ 5 , 0 0 0 Feb 2 Received a bill for Utilities Service $ 3 5 0 due next month Feb 2 Received a bill for prepaid advertising $ 6 0 0 due next...

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...