Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Replace NULL-Empty with Zero

Question

Views

Comments

Guillermo Bueno Rank 2 - Community Beginner

Jul 31, 2020 1:21PM edited Aug 13, 2024 7:11PM in Oracle Analytics Cloud and Server

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')))

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Replace NULL-Empty with Zero