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

Sandeep Andhale

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

Gianni Ceresa

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?