Hello
I have a grid for customers, all other field is a custom field type, I use sql query to get sum(value) from mysql db.
I need to sum two fields (red), subtract them from (green) field and put the result in (yellow) field, so in my grid onRecord:
{result-yellow} = {field-green} - ({field1-red}+{field2-red});
The result is correct in the first row, unfortunately it will be the same on other rows, even in the grid total its the same number for the first row, how to solve this problem
please see attached image
Thanks in advance