Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Custom Data format

Question
1
Views
0
Comments
user12863665
user12863665 Rank 6 - Analytics Lead

i want to display 0.00 for null values in pivot view.so i used customer format - #,#.0;-#,#.0;0.00 to display it. but issues is when i export report output to 2007+, all values which are updated with 0.00 from null are showing as text. Anyone suggest me how can i fix this?