calculate taxe per month

[zied_ahmed1]

Hello,

I have this code and i need to calculate the Taxe per Month:

NoConcatenate

    Table2:

    load

          Plaque,

          date,

          Materiel,

          Plaque as Plaque,

          sum(statut_endom) as statut_endom,        

          sum(statut_actif)  as statut_actif,

          sum(statut_inactif)  as statut_inactif,

          sum(statut_bloque)  as statut_bloque,

         (sum(statut_actif)/day(date)) as Taxe

          resident Table1

    Group by date_flotte,Materiel_flotte,Plaque_flotte,Plaque;

    drop table Table1;

[zied_ahmed1]

i will give you an example if today 2 Mai 2017 the Taux of one plaque who have statut actif wil be 1/2 so the taux will be 0,5 for today,Tomorrow i will do 1/3 + 0,5(value of yesterday)