Trouble with triple data!

[timmy]

Hellow,

can somebody help me with this problem?

invoice effective_date name product description long_description quantity val =sum(quantity)
OP/I217596 29/01/2010 00:00:00 BASF AGRI-PRODUCTION RP0072 - - 60 0 180
OP/I217596 29/01/2010 00:00:00 BASF AGRI-PRODUCTION 5L C95 HDPE 220G M GRIFAP JAUNE P072 10080 56 30240

This data comes out of the pivot table box that i have created.

You can see that the formula triples my actual data...

How can i solve this and why does this happen?

[#2]

Hi Timmy,

Without know your data structure, help you, will be a little complicated.

Regards.

[timmy]

I understand but posting the structure is difficult 🙂

[#4]

the formula wont be tripling the data, something else will be. if you did coun(quantity) instead of sum you'll probably get 3.

can you attach the file and i can help you look for the duplicate.

Thanks

Rick

[Clever_Anjos]

Could you post a sample of your data?