
1. Re: How do I calculate ratios using the data in two columns to create a ratio?
ShivaRam Chennapragada Apr 9, 2018 7:35 AM (in response to Bill Benton)If you need the result in %, create a calculated field 'Ratio' > SUM([A])/SUM([B]). Click 'OK'. You should now see it under Measures, rightclick > Hover over 'Default Properties' > Select 'Number Format' > Select 'Percentage' and Decimal Places you want. Attached screenshots,
Hope this helps.
Thanks,
Shiva.

2. Re: How do I calculate ratios using the data in two columns to create a ratio?
Bill Benton Apr 9, 2018 7:54 AM (in response to ShivaRam Chennapragada)ShivaRam;
Thank you for the screen shots and attached.
I am a “New” Tableau user.
Ideally, I would like to show both the numerator for all rows e.g.
Thank you, in advance for your help with this “newbie”.
Bill

image001.png 6.5 KB


4. Re: How do I calculate ratios using the data in two columns to create a ratio?
Bill Benton Apr 9, 2018 8:26 AM (in response to ShivaRam Chennapragada)Exactly!
Here’s the what the Sheet looks like.
[cid:image003.png@01D3CFF4.91FE5350][cid:image001.png@01D3CFF3.D82BD470]
The 1 and 3 under 2017 refers to 1 = Private Passenger Cars and 3 = Commercial.
Here how the it would work.
1 (Private Passenger Cars) 16Losses Paid 1,391,737 would be divided by 1 (Private Passenger Cars) 11Premium 1,041,539 for a Loss Ratio or 1.33 Or 133%.
3 (Commercial) 16Losses Paid 842,526 would be divided by 3 (Commercial) 11Premium 272,641 for a Loss ratio of 3.09 or a Loss ratio of 309%.
I know I’ll have to create a calculation for Loss Ratio – Not sure how.
Bill
Thank you.From: ShivaRam Chennapragada
Sent: Monday, April 09, 2018 10:57 AM
To: Bill Benton
Subject: Re:  How do I calculate ratios using the data in two columns to create a ratio?
Tableau Community <https://community.tableau.com/?et=watches.email.thread>
How do I calculate ratios using the data in two columns to create a ratio?
reply from ShivaRam Chennapragada<https://community.tableau.com/people/shivaram.chennapragada.0?et=watches.email.thread> in Forums  View the full discussion<https://community.tableau.com/message/748394?et=watches.email.thread#748394>

image003.png 1.0 KB

image002.png 1.3 KB

image001.png 7.1 KB


5. Re: How do I calculate ratios using the data in two columns to create a ratio?
ShivaRam Chennapragada Apr 9, 2018 8:43 AM (in response to Bill Benton)If I understand correctly, is this what you're looking for?
If so, refer to the workbook and find the 'Loss Ratio' calculations under Measures. Hope this helps.
Thanks,
Shiva.

Bill_v10.2.twbx 10.2 KB


6. Re: How do I calculate ratios using the data in two columns to create a ratio?
Bill Benton Apr 9, 2018 8:47 AM (in response to ShivaRam Chennapragada)That’s it!
Where would I find the workbook?