Problem with function SUM()

[eduardo_dimperio]

Hi everyone,

I finally end my code (hope so), and thanks to all that spend some time to help me.

Now the last problem that i dont understand is using the SUN() function in the graphic.

If you look the image for the meter 32646 i only have 1 value 0,17 so when i use SUN(CONSUMO_REAL0), I expect output 0,17.

Why for all saints im getting 2,04 ????

[MK9885]

Cus it is doing sum for all related OID_METER 32646 for CONSUMO_REAL0.

Maybe try Sum(Distinct(CONSUMO_REAL0) ???

[sunny_talwar]

It seems that your data is repeating for some reason. In this particular case the OID_METER might be repeating 12 times (12*0.17 = 2.04). Although you can fix this on the front end of the application, I would suggest fixing this in the back end because you don't want to carry a single row 12 times if you don't have a real use for it

[eduardo_dimperio]

Yah, but by the image i have only 4 measures to this meter, 1 =0,17 and 3 = null.

How this sum could be equal 2,04?

[MK9885]

I don't know how your data is or script is....

Maybe try what Sunny is saying in below reply?

[eduardo_dimperio]

Hey Sunny, i saw this 12*0.17, but still dont get why this happen.

About carry a single row 12 times if i dont use SUN() its not occur. I think that will be better use Max() instead SUN()

[sunny_talwar]

You have many options, you can do Only(), Max(), Avg(), Min(), Sum(Distinct...).... but all these are workarounds. None of them solves the underlying issue that you have multiple rows with same information.

[eduardo_dimperio]

I agree about thats only workarounds, but why not apear that repeated values when i dont use any agreggation?

[sunny_talwar]

Because a table only show a unique combination of all the fields. If you add another field where the two rows would not match, you will see your multiple rows.

[parimikittu · Accepted solution]

Hi,

The reason for repetiton is due the underlying data modelling.

1) the table which contains OID_METER,Consumo_real0 columns might be joined with other tables, hence causing duplicate records

2)the columns OID_METER and Consumo_real0 might be in different tables and are associated using a common key which might have 12 entries.