Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello~
I just want to ask why the function sum() doubles up my original value.
what do you think are the causes?
Thanks,
Donna
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.
Please check the data before joins with other table and after joins. Duplication occurs for joins. It will helps u.
can please come up with sample file if possible
alright, i will be checking my script and get back to you. thanks