1 Reply Latest reply on Aug 17, 2016 7:55 AM by Dixon Kavanaugh

    simple calculated field for percent

    Dixon Kavanaugh

      Hi All,

       

      I'm looking to add a % column into a cross tab however it's just not working out. the data extracted from the excel sheet is correct but shows incorrectly and when we create a calculated field it shows incorrectly. It's a simple calculation so I'm sure the solution is simple yet it eludes me. I've uploaded the data source as well as the workbook. we are looking to create % answered and % unanswered columns. As an example Answered = 6, Total Calls = 7 so 6/7 should be .85 but we get 3. Your all's help is appreciated. 

       

       

      Thanks.