2 Replies Latest reply on Dec 30, 2011 6:08 AM by Amy Song

# Simple division question

Hi there, I have 2 type of cargo, belly and freighter, and a total (with some other metrics in between).  I am looking to create share of each (% belly and % freighter) from the total cargo number.  In the attached example you see Alaska Airlines with 1750 metric tons of belly cargo and 134 metric tons of freighter cargo, totaling 1884 metric tons of cargo.  I created a calculated field to divide belly and freighter by total in attempt to get share (should be 93% and 7%) but instead it shows 287% and 13%.  The datasource does have several different months/years in it but I am unsure how that is affecting this calculation since the other data in the table look fine.  Thanks if you can please help out!

Oh and just a heads up, this workbook was created in Tableau 7.

Thanks,

Amy

• ###### 1. Re: Simple division question

looks like you want to SUM() before you divide, use a formula like:

`SUM( [Belly cargo metric] ) / SUM( [Total cargo] )`

• ###### 2. Re: Simple division question

Ah, thank you Joe!  Should have known that but still learning...

:)