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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: SAP BOBJ User Group DC: Nov 30.

[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: 126
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.0281 seconds using 17 queries. (SQL 0.0048 Parse 0.0007 Other 0.0226)
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