11.3.4 Activity: Add Formulas to Profit & Loss Report Module

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

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!