nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

11.3.4 Activity: Add Formulas to Profit & Loss Report Module

alexistivi

Hello everyone, on my activity, the totals for the other expenses are not populated as the same with the should be result in the activity. Here are some screenshots.

This is my model:

This is the should be:

Any solutions to this? Thank you

Accepted answers

All comments

SriNitya

Hi,
Check if Forecast ? boolean in SYS09 module. In all the line items the if SYS09 Forecast ? is effecting the output and as the data in Data module is 0 so it in line items data is coimg '0'.
Check Forecast ? lineitem.

alexistivi

Hey @SriNitya, yeah it is already in Boolean format please see attached screenshot. Thanks

PujithaB

Hi @alexistivi
There are few possibilities here.
1. Values wont exists in OTH01 module

2. DATA01 P&L Module doesnot have values.

3.Dimensionality differences between OTH01, DATA01 and to the REP03 module

Let me know if any of the possibility exists in this scenario.

Thanks
Pujitha

alexistivi

Hi @PujithaB, thanks for the response. DATA01 P&L Forecast version has no values due to the imported data that has no Forecasted values.

PujithaB

@alexistivi Great to know that you are able to trace back with the points provided.

SriNitya

Check the data in OTH01 Non Employee Expenses Module

Yogendrsingh5july

Hi @PujithaB i am unable to get the right total in the module,

my module has values in forecast where it was mentioned that it should have no value.

due to this while filling the formula in the REP03 profit and loss report it is taking reference from here rather than OTH01 NON EMOPLOYEE EXPENSE

KINDLY GUIDE ME HOW TO CORRECT

I am sharing the screenshot in a order for you to see

this is where the forecast should have no value as mentioned while importing the data.

this is the answer i am looing for attaching below

this is what my report is showing

this is my setting for the forecast

this is the value it is supposed to pick form this module for it to work right

as per this formula

IF 'SYS09 Version Details'.Forecast? THEN 'OTH01 Non Employee Expenses'.Shared costs ELSE 'DATA01 P&L Actual and Budget'.Shared Costs

kindly help

VarshithaReddy

Hi @yogendrsingh5july did you find the answer for the error you got, I'm getting the same error.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…