Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 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
Replace NULL-Empty with Zero
Guillermo Bueno
Rank 2 - Community Beginner
Good afternoon,
Can someone help me with the following question?
If any of the values under code:02,code:03, code04 is blank my calculation do not work, how can I replace what I believe are empties not nulls for a 0 (zero)?
SQL query:
(FILTER ("Account Revenue"."Sales Revenue USD" USING ("Account Revenue"."Cd" ='04'))-FILTER ("Account Revenue"."Sales Revenue USD" USING ("ESP"."Account Revenue"."Cd" ='03')))
0