Need help for sum function

[victorchl]

Hi,

I found a problem with my element sum function. When I enable it. In the front-end, the following message shown on the top:

SELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.editorfee AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.editorunpay AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `skpub`.`id`, skpub.journalstatus AS value, 'calc' AS label FROM `skpub` LEFT JOIN `yng4k_users` AS `yng4k_users` ON `yng4k_users`.`id` = `skpub`.`skchinae` WHERE ( `skpub`.`id` IN (22, 38, 29, 58, 4, 30, 61, 78, 89) )) AS t GROUP BY label

And when I go to the list setting, then group by this element. The sum is 0. I don't know why it's happened. Can anyone help~~~~Thank you!