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 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?
