I'm trying to add a column to my P&L report to show each line as a percentage of total revenue. What I tried. I added a percent column. I added a formula line to the Net Profit line. (REV_COPY.balance + OIN_COPY.balance - COS_COPY.balance - EXP_COPY.balance - OEXP_COPY.balance - DEP_COPY.balance)/ REV_COPY.balance * 100 The problems. When the revenue is zero I get a divide by zero error. AI recommended N(REV_COPY.balance), but that is causes and error "Could not expand N" When trying to add

Percentage of Revenue on Profit And Loss Report Odoo 18.0 Enterprise

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

All apps

accounting

1 Antworten

966 Ansichten

I'm trying to add a column to my P&L report to show each line as a percentage of total revenue.

What I tried.

I added a percent column.
I added a formula line to the Net Profit line.
1. (REV_COPY.balance + OIN_COPY.balance - COS_COPY.balance - EXP_COPY.balance - OEXP_COPY.balance - DEP_COPY.balance)/ REV_COPY.balance * 100

The problems.

When the revenue is zero I get a divide by zero error. AI recommended N(REV_COPY.balance), but that is causes and error "Could not expand N"
When trying to add this formula to the expense lines I get an error. Groupby feature isn't supported by aggregation engine.

Where am I going wrong? Is there documentation on how this works?

I also face the same problem. Can anyone help? Thanks

Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!

Registrieren

Verknüpfte Beiträge	Antworten	Ansichten
How to Manage Cash Basis Accounting Reports Without Using Cash Basis Under Tax (Odoo v18) Gelöst accounting	1 Okt. 25	132
Need help building a extended view over the accounting dashboard view accounting	1 Okt. 25	154
How can I link a standard general ledger account to a customer? Gelöst accounting	1 Okt. 25	242
When supplementary delivery orders for the previous month are entered at the beginning of the current month, how to allocate the dates of accounting entries generated by the supplementary entry of shipments in the current month to the previous month? accounting	0 Okt. 25	141
Special tax regime for profit margins accounting	0 Okt. 25	128