Skip to main content ↑ ↓
Topic: custom field expression sum by unique id (Read 1527 times) previous topic - next topic

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

Re: custom field expression sum by unique id

Reply #1 –
@warfreak‍ please note that you cannot use full queries on custom field expression, you can only do calculations of the current page fields.

Re: custom field expression sum by unique id

Reply #2 –
An example please