How to use group with scope when joining 3 tables

I have the following models:

class Client < ActiveRecord::Base
has_many :accounts, dependent: :destroy

class Account < ActiveRecord::Base
belongs_to :client
has_many :operations, dependent: :destroy

class Operation < ActiveRecord::Base
belongs_to :account

I manage to extract clients and all their operations grouped by client as follows:

scope :operations_by_client, joins(:client, :operations).select(‘clients.firstname, clients.lastname, sum( as total’).group(‘, clients.firstname, clients.lastname’).order(‘clients.lastname’)

Now how to tune/change it in case if I don’t need to calculate SUM of the operations but to use a special method that would calculate the sum of all the operations for the specified client? I mean that I should exclude certain total values from the calculation depending on the operation type.

Thanks and regards

Finally I implemented ut as follows:

class Client < ActiveRecord::Base

scope :accounts_sum, includes(:accounts => :operations).group(‘’).order(‘clients.lastname’)

def accounts_balance unless accounts.empty?

And here are the changes in the OperationsController:

def index
@operations = Client.accounts_sum.paginate(page: params[:page])
@total = unless @operations.empty? #to be able to display the total of all the existing accounts.