Hello, I have a need to query the DB for all products sold to a client then get the total. This then needs to be displayed in a field. I am using SugarCRM CE 6.5.13 I would greatly appreciate any assistance. Thanks.

Hi guys ! I have a problem with my Opportunity module. So I have 2 custom fields: Category (which is a dropdown: H&S, ICT, TBD) and Reference (which is a calculated field). The reference is a mix of some other data, the thing is: for some reason it only…