Translate

Friday, 2 December 2011

OBIEE Pivot Table nulls to Zeros for empty Rows

When you create a pivot table and you see nulls in the measures part , You want to see 0 or 0.00 instead

Just change the data format on the report column in the report itself too

Custom format

#,##0.00;-#,##0.00;0.00

For Nulls if you want zeros 0 instead of null then enter:
#,##0;-#,##0;0

For a Dash
#,##0;-#,##0;-

A custom Message instead of null
#,##0;-#,##0;no data

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...