Welcome to Tableau and the Forum - the answer will depend on how the data is structured - Are A and B separate dimensions? We usually like to see your TWBX workbook to see the data and what you have done
that said if they are separate dimensions sum(A)/Sum(B) is the usual approach
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim and thanks in advance.
Below is a clip of my sheet in which I want to divide the following columns to get a ratio.
16-Losses Paid 2017 1 / 11-Premium 2017 to get a ratio of
1,391,737 / 1,041,539 = 1.33 or 133%