none
Number formatted to text when exporting to Excel RRS feed

  • Question

  • I have calculations in the the expression for a matrix column.  If the initial value is zero and I divide it by another number, it shows up as 0 in the report and exports as a numeric field to Excel.  However, if the initial value is 0 and I multiply it by another number, it shows up as 0 in the report, but exports as a text column.  If I take the result of the multiplication and divide it by 1 in the expression, it will show as a 0 and export as a number. 

     

    If I do no calculations, it will display as 0 and export as a numeric.

     

    Has anyone else seen this issue?  Possible bug?

    Monday, April 16, 2007 8:36 PM