In our Odoo 17 environment we have several analytical accounts such as AC-1, AC-2, AC-3 etc.. and same time we have invoiced customer invoices, vendor bills against those analytical accounts. I want to create a custom report for each row as above analytical account and its balance for given date, month and year as column while duplicating standard exisisting profit and loss report. Therefore, I have used below formulas to get a particular analytical account balance, unfortunately it did not work. Here as my custom expressions are,

Label ​Computation engine ​  ​ ​ ​Expression

balance ​Odoo Domain                                 [('account_id.analytic_expression','=',AC-1)]

sum_if(balance, domain=[('analytic_line_ids.analytic_account_id', '=', 409)])

sum_if(balance, domain=[('analytic_distribution', 'like', '"409"')])

_report_custom_engine_my_sum_if(balance, domain=[('analytic_distribution', 'like', '"409"')])

_account_filter('*', 'analytic_distribution', 'like', '"409"')

those expresessions did not work. 

Can anyone know that how to get analytical account balance using correct expression to get the account balance ?

Thanks,