
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Duplicates lines in total expression
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 ?
- Tags:
- duplicating


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please post sample data with QVW file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I posted my qvw file

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I posted my qvw file
