I can't get the sum function to work with duplicate values

[FcoSamuel]

Putting it in automatic totals doesn't work and I can't use it in a pivot table. I need it to automatically do the sum of all the values.

Putting it in KPI doesn't work for me either. any ideas?

[Or]

Write your formula so that it sums up correctly. Without knowing what the formula is, it's impossible to try and help you correct it.

[FcoSamuel]

sum(value)

[Or · Accepted solution]

Assuming Value is a field taken from the same table as Mes Documento, it should work and sum correctly. If they are from two separate tables this may be a case where there's actually only one Value to sum, and it's being displayed twice because you put it in the same table with a field from a different table? Providing sample data would help understand the situation here, I think.

[FcoSamuel]

They are in different tables. It is very likely a model / relationship problem with the tables just as I was afraid.