Information générale
Catégorie:
Gestionnaire de rapports & Rapports
E C,
You have to be careful with averages done within reports. As Neil pointed out, if the staff member has 2 telephone records, his salary will be counted twice and the average will not be correct.
You may need to do the average calculation outside the report and assign it to a memory variable or property of your calling form.
The problem I had with averages was with averaging over records that had value > 0 rather than over all records. I had to get the numerator and denominator with report variables.
>I using SQL to select the records I wanted as follow :
>
> SELE pay.staff,pay.salary,staff.tel ;
> FROM pay,staff ;
> WHERE pay.staff = staff.staff ;
> INTO CURSOR temp
>
>The problem is if staff have 2 tel, when I run the report the average salary will be incorrect.
>
>Can anyone help me to find out the solution
>
>
>
>
>Thank u.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement