Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Exporting to excel

    Posted 08/02/21 02:24 PM

    I am having an issue with one of my reports exporting a numerical field as text to Excel. 

    Can anybody tell me where to look to fix this issue.  Other reports export fine

    Thanks




    ------------------------------
    Harold Dieter
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Exporting to excel

    Posted 08/03/21 05:53 AM

    Harold Dieter – could you elaborate on the field in questions if possible?  Possibly tell us the value and the exported value.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 3.  RE: Exporting to excel

    Posted 08/03/21 11:29 AM
    When the report is downloaded as excel all numerical cells are stored as text in the excel spreadsheet

    ------------------------------
    Harold Dieter
    ------------------------------



  • 4.  RE: Exporting to excel

    Posted 08/04/21 08:33 AM
    Sent from my iPhone