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

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to use sumif like excel in OBIEE Total Credit Line =SUMIF(B:B,B2,C:C)

Received Response

52

Views

2

Comments

User_N8GVJ

User_N8GVJ Rank 1 - Community Starter

Jan 23, 2023 4:07AM edited Aug 13, 2024 4:58PM in Oracle Analytics Cloud and Server

0

Answers

Federico Venturin - Oracle Mod

Jan 23, 2023 6:43AM

Hi @User_N8GVJ ,

You can calculate Total Credit Line as follows in OBIEE (of course you need to replace the names in the expression according to your subject area):

SUM("Balance" BY "Customer Number")

0
User_N8GVJ Rank 1 - Community Starter

Jan 23, 2023 6:19PM

Hi Federico,

Thank you very much.

I'm learning OBIEE front and back end of it.

0