X-Git-Url: http://gitweb.pimeys.fr/?p=scripts-20-100.git;a=blobdiff_plain;f=sum_transacs_by_categorie.py;h=900ed808b989030c3a0e730e8f02aeb1085f2a3e;hp=3e26574d5fe95fc6a92dd25ec39453331cb0cfc8;hb=a21ba9243cdf8ff4daa6192ee7bb31d9d3dc8d01;hpb=e0db13fbfc70a500ec82244f3cbc871b0ecbf5a0

diff --git a/sum_transacs_by_categorie.py b/sum_transacs_by_categorie.py
index 3e26574..900ed80 100755
--- a/sum_transacs_by_categorie.py
+++ b/sum_transacs_by_categorie.py
@@ -29,6 +29,7 @@ def get_sum(descriptions, debut, fin):
           AND date >= %(debut)s
           AND date < %(fin)s
           AND destinataire = 0
+          AND montant != 0
           AND description = ANY (%(descriptions)s);
     """
     con, cur = getcursor()