Hello all,

I want to create financial ratios in odoo. I'm using the Odoo spreadsheet for that.

How do I calculate ratios that take whole classes for example :

Class 1 divided by Class 4 (random)

I know how to take individual accounts such as 707100, using the ID of the account :

ODOO.PIVOT("1";"balance";"account_id";"659";"date:month";"07/"&ODOO.FILTER.VALUE("Year"))

Looked online, didn't find anything, maybe wasn't wording it right...

Thanks in advance for your help...