Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Could it be a datatype issue? ifnull() works for me with both string and numeric data types without any additional conversion. Thanks, pras
-
Hi Stephanie, Use 'ifnull()' function to replace null with 0. You can do this by editing the formula on the field on which you want this to happen. For e.g., if the field name is 'FLD_NAME', the formula would be ifnull(FLD_NAME,0). Thanks, pras