Exporting Summary Reports to Excel
I created a computed column that displays a "1" if the condition is true, and a "0" if the condition is false. The numbers display correctly in the Taleo preview window.
But when I export the numbers to Excel, the "1" displays correctly, and the "0" displays as "#VALUE!". These cells contain a formula instead of a number "=SUM(DataSheet1_MainTable!$D$2:$D$1434)"
Next I created a summary report which inserts totals for each of the computed columns. The numbers are displayed correctly in Taleo when I view the sample data. When I export these numbers to Excel, I have the same problem as above. I can view all the numbers in a Word document, but not in an Excel document.