Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - warfreak

1
Questions / custom field expression sum by unique id
Hi,Guys,

need some help, i have 2 column (vatable_sales` + `salary_remittance) and i what to put a total column based on  unique id , now if i put my code on custom field expression  is not working, but already tested on my sql console its working fine.

Code: [Select]
SELECT SUM(`vatable_sales` + `salary_remittance`) FROM bill_recording GROUP BY bill_no



regards