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.
SELECT SUM(`vatable_sales` + `salary_remittance`) FROM bill_recording GROUP BY bill_no
regards