On account , we have contact. There is a custom object called employee having lookup on contact and custom field called salary. I want to display the sum of all employee salaries on account record . Can we write an soql query for this?

Raj Vakati

Try this..

Select Sum (sal__c) from Employee__c groupBy Contacts.AccountID__c

Need an account? Sign Up

Have an account? Sign In