2 Replies Latest reply on Apr 5, 2018 6:16 AM by Bill Benton

    Beginner - Calculating a ratio using two columns of data

    Bill Benton

      I am a Tableau "newbie" and I have a sheet of data with multiple columns in which I want to divide column A by column B to obtain a ratio e.g. and then format it into a percentage.

      I created a calculation (A/B) and when I add the calculation to be a new column all I'm getting is a whole number e.g 247.

       

      Can you help me to determine what I'm doing wrong?

       

      Thank you!

       

      Bill