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.
Ok - I found the answer in the knowledge base under "calculated field returning incorrect results". If this is something your running into find the inofrmamtion here: