Duplicates lines in total expression

[oboute]

Hello all,

I have a table with some calculation (conditions with dates and so), and my total works fine.

But, when i want to do a "summarized" table with just total, it removes costs :

Here is my calculation :

I tried to change "Montant commande" by Sum(Montant commande), but it duplicates me costs  :

I checked, normally i have juste one "montant commande" by N° BT, i don't understand why it's duplicating lines ...

Any idea ?

[jayanttibhe]

Can you please post sample data with QVW file?

[Anil_Babu_Samineni]

When you talking about Duplicates it should show same value for two times. on my visualization i didn't see any duplicates over there. Can you share the excel and please post the expression on wall

[oboute]

Hello,

Here is a sample.

I know i could use a Sum(Distinct "Montant Commande") but i don't want to do that because it won't work with other calculation after, i would fix the problem at beginning by not duplicating those amounts

[oboute]

I posted my qvw file

[oboute]

I posted my qvw file