Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
on number field SUM() function not give correct sum value

Hello Friends,
I have Created one custom child object on Opportunity on that I have one number field I want sum for that field
Because of that I have use SUM(Field Name) function but that giving me wrong sum
Thanks & Regards
Sandeep Andhale
Answers
-
Hi Sandeep,
Do you agree that you actually don't really provide anything to help us helping you?
You are the one with the model in front of you, with the data in front of you and with the "wrong sum" in front of you.
So start by defining "wrong": is it really wrong (like 1 + 2 = 5) or it's just not what you expect for any reason?
What is OBIEE doing to actually return you that number you define wrong?
What does the LSQL looks like? What does the physical SQL looks like?
Based on above logs do you understand why OBIEE is doing that calculation?
0