1. Important notice about Cloudbleed - if your site uses the Cloudflare CDN, and you intend to follow the Joomla security team's advice to change your site "secret", you MUST READ THIS NOTICE.
  2. Fabrik 3.6 Released Remember to backup and test your backup before proceeding with this update. Please report any problems you might experience with this new version here on the forum. You are safe to upgrade to Joomla! 3.7 and PHP 7.x with this version of Fabrik. View the blog for more details on this release.

Need help for sum function

Discussion in 'Standard Support' started by victorchl, Feb 17, 2017.

  1. victorchl

    victorchl New Member

    Level: Standard
    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!
     

Share This Page