BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: SAP TechEd: Sep 28.

[Deski (XI)] Thousand format import from Excel


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
KISS-KIZITO
Forum Member
Forum Member



Joined: 23 Oct 2016

Posts: 1



PostPosted: Thu Aug 31, 2017 5:38 am 
Post subject: Thousand format import from Excel

Hello, I have a problem when importing data from Excel with thousands and Millions, same columns are imported well,in same other I have a problem e.g if I have 100,000 in Excel i get 100 in Deski also if I have 1,000,000 in Excel I get 1 in Deski. It is strange because I formated all the columns as custom using excel 2010 and I saved the file as 97-2003 Excel file before to import into Deski. Thank you for your help
Back to top
Maddye
Principal Member
Principal Member



Joined: 09 Jan 2009

Posts: 116
Location: Cambridge


flag
PostPosted: Tue Sep 05, 2017 8:53 am 
Post subject: Re: Thousand format import from Excel

Try formatting the Excel as number with the 'Use thousand separator' check box ticked (using the appropriate separator for your locale), and also ensure your Deski output is formatted as a number.

Business Objects doesn't like 'hybrid' inputs/outputs, so if some of your numbers have commas or something it thinks is a decimal point, it may be treating the value as text not as a number or truncating the decimal. (It does the same with dates as well...)

_________________
Next available for contract work November 2017
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0110 seconds using 17 queries. (SQL 0.0019 Parse 0.0002 Other 0.0089)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo