Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BIP report when exported in EXCEL, data from filled cells is moving to blank cells
User_CKBFD
Rank 1 - Community Starter
Few of the columns in Excel have blank cells (no data for those records). So, the column which has the data, it's values are shifting towards the cells which are blank and getting filled in there.
This makes the data inaccurate.
Please note that column I, J and K in Excel are a splited column in RTF(One column splitted into three via RTF)
Please please help!!!!!!!!!
0
Answers
-
0
-
Can you try setting the "Keep values in the column" - True under report properties → formatting → Excel 2007 output and try again?
Thanks.
0
