X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;ds=inline;f=bde%2Fstats%2Fdepenses.py;fp=bde%2Fstats%2Fdepenses.py;h=248411b44f02126f41605c7c3ac722c4ddac08bc;hb=3ffdf940ed5462261cb65c46890b9d81006735bc;hp=1997d4c1354cc9ab84cbe18a834d120048ffe51b;hpb=c19278d817c4905042175dfcef5ac8965410acad;p=scripts-20-100.git diff --git a/bde/stats/depenses.py b/bde/stats/depenses.py index 1997d4c..248411b 100755 --- a/bde/stats/depenses.py +++ b/bde/stats/depenses.py @@ -16,7 +16,7 @@ create_temp_table = """ END )/100.0 AS numeric(10,2)) AS depenses, CAST(sum( - CASE WHEN destinataire = %(idbde)s THEN montant*quantite + CASE WHEN destinataire = %(idbde)s THEN montant * quantite ELSE 0 END )/100.0 AS numeric(10,2)) AS gains