Aggregate And Calculate A Percentage

[kfeeney16]

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

[Aurora]

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

[Aether]

Hi @kfeeney16,

The best approach/process with this is to use "Totals and Aggregation" in a tabular DataPage.

Check this documentation for further information:

https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

I hope this helps  

~WatashiwaJin~

[ianGPT]

Hello,

Just wanted to also share a reference for calculated values https://howto.caspio.com/function-reference/