Question on Formula for headers and line items

I am trying to create formulas for a P/L account. I need Line items but I need the formulas across the columns to be different. I cant find any details to this on your website.

How is this possible?

Gross will link to another module

I/C will be Gross multiplied by % with another module

Net I am taking the 1st two away from one another

profit_and_loss_77024.PNG

Accepted answers

All comments

anirudh

Hi @ciara

You will have to employ Line Item Subsets

Create line items for each member of the P&L and apply formulas as desired

Then make these line items into Line item subsets

More details here

https://help.anaplan.com/anapedia/Content/Modeling/Dimensions/Line_Item_Subsets.html

Let me know if you need more help

Regards,

Anirudh

ciara

@anirudh Hi, Thanks, I have tried that and the forumlas wont breakdown. For the Revenue line, I need a different formula in each column and when I try insert subsets the formula drags down to each line item in the column

einas.ibrahim

Hi @ciara
Before I suggest a solution can you please help me confirm my understanding of the issue

The P&L line item such as Revenue and COGs are Line Items in the modules?
The items in the columns are in a List?
What are the other dimensions in the module?
What is the logic for calculating the different values in the columns?
1. Some are multiplied by a ratio from another module and others are a simple addition/subtraction?

I had to add a KPI line item on a P&L which had a different calculation for each P&L line item (P&L was a Line Item Subset). I think that might work with your situation.

ciara

Thanks for getting back to me.

1- The Line items are line items (The normal P/L items)

2- I put the rows as a subset (Ext RI, Net, Gross etc)

3- Other dimesions are time, and entities. ( I hope to link the gross to another module then use the other columns to build formulas off the Gross figures.)

4. So the Gross is the total (which I am taking from another module) then the other ones I am using ratios to multiply the gross to break it down and others just to subtract.

My issue when doing this is the formula will link all items in gross to revenue rather then to the matching name.

Hopefully I am making myself clear. Apologies if I am not.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385