I just want to ask why the function sum() doubles up my original value.
what do you think are the causes?
u have duplicates in ur table
if u see frequency of column amountfield then u will understand.
use sum(distinct amountfield)
if i use distinct, it won't tally with the 'total' at the end of the table.
i have tried distinct but end up not equaling with the summed values and the total displayed.
can please come up with sample file if possible
Please check the data before joins with other table and after joins. Duplication occurs for joins. It will helps u.
alright, i will be checking my script and get back to you. thanks
Retrieving data ...