on number field SUM() function not give correct sum value — Oracle Analytics

Oracle Analytics Cloud and Server

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

on number field SUM() function not give correct sum value

Received Response
1
Views
1
Comments
Sandeep Andhale
Sandeep Andhale Rank 3 - Community Apprentice

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?