Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank you, Nathan. For the solution and the feedback on my response.
-
Thanks for the reply Bhaskar, this is in OTBI. The formula I currently have to exclude accounts with 0 balance is this: (IFNULL("Base"."Beginning Balance",0)+IFNULL("Base"."Period Net Activity",0) <> 0) I'm looking for a way to amend that formula so account "500" is excluded from the filter. In essence, I want to apply the…