I came here because I have a problem with view calc module and several lines in my field collection. So first the result of my view look like this :
All this fields are in the same content type, and I put
sum calculation on each fields. But it's seems the value of the field is multiplied by the count of lines in my field collections. So for the first sum(Montant HT) the calcul done is :
8600 + 51600 + (3101.26 * 5) + 2962.99 + (42000 * 3)
For the column
paid sum I don't know how the sum is calculated I doesn't understand.
I tried to use distinct but it didn't work, so how can I found the right sum for all my column ??