Jump to content
  • 0
kfeeney16

Aggregate And Calculate A Percentage

Question

Pretty straightforward, so I'm probably missing a topic with the right answer, but hopefully someone can help.  I've got a table of sales reps with a column for their total number of sales and total number of cancels.  I've got a data page showing each sales rep and their counts plus calculating their cancel rate (just cancels/sales).

 

These agents are all grouped by offices, so I'd like to aggregate each office...I've got that totaling for the sales and cancels, but not sure how to calculate the cancel rate in the office.

 

Any help would be great...thanks.

 

Kevin

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi Kevin !

 

You can add a second Aggregate Field, select Field that counts " cancel rate(cancels/sales)", select " Formula" radio button, and insert the following formula there:

 

SUM(Cancels)/SUM(Sales)

 

Hope this helps you! 

 

Aurora

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...