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: Shipping costs Formula error

gourav1kumar

Hi,

I need help for the formula error occurring in Shipping costs. Please find the screenshot for reference.

Thank you

Gourav

11_127302.PNG

Accepted answers

HemachandanReddy

Hi @gourav1kumar ,

Try to assign a Parent member or Top Level to your E1 Departments list. You can give it a name like "All Departments" and save it in the list. This should be able to fix your error in the formula.

Regards

Hemachandan G

HemachandanReddy

Hi @gourav1kumar

Can you check the configurations tab in the list - G2 Country and E2 Employees# ? If this activity has not been performed correctly, then the data will not be flowing into the modules.

G2 Country -- Parent Hierarchy - G1 Region (Select from drop down)

E2 Employees# -- Parents Hierarchy - E1 Departments (Select from drop down)

The solution that I provided in the first instance is a general solution in case there is no parent hierarchy setup or if it is a flat list.

Thanks,

Hemachandan G

All comments

HemachandanReddy

Hi @gourav1kumar ,

Regards

Hemachandan G

gourav1kumar

@HemachandanReddy

It has worked. I have given the Parent Hierarchy for E1 Department as "--Employee Lists-- (All Departments)" and the formula has been accepted.

Thank you so much for the assistance 👍

- Gourav

pic_127370.PNG

gourav1kumar

@HemachandanReddy

Now there is one more error, data hasn't loaded for Shipping costs, Rent, Utilities, Shared Costs & Other costs.

Please find the screenshots attached for reference.

Thank you

Gourav

Firstly, the formula says - If your current version is set to forecast then you are bringing the data from OTH01 module or else you are bringing the data from DATA01 module.

Please check if the below 2 points are mapped or loaded with correct data:

1. SYS09 Version Details - Forecast ? line items has been set to current version.

2. OTH01 Non Employee Expenses module has been loaded with the correct data.

So, if the current version is selected as forecast from the system module then whatever data is present in OTH01 module will flow into your reporting module as per the formula into respective line items.

Regards,

Hemachandan G

gourav1kumar

Hi @HemachandanReddy

I have verified and all the details matches correctly.

Attaching screenshots for reference.

Thank you,

Gourav

OTH_expected_127377.PNG

OTH01_Mine_127377.PNG

SYS09_127377.PNG

HemachandanReddy

Hi @gourav1kumar

Can you check the configurations tab in the list - G2 Country and E2 Employees# ? If this activity has not been performed correctly, then the data will not be flowing into the modules.

G2 Country -- Parent Hierarchy - G1 Region (Select from drop down)

E2 Employees# -- Parents Hierarchy - E1 Departments (Select from drop down)

The solution that I provided in the first instance is a general solution in case there is no parent hierarchy setup or if it is a flat list.

Thanks,

Hemachandan G

gourav1kumar

Hi @HemachandanReddy

I got the result finally. I mentioned the Top Level (All Departments) to wrong list (--Employee Lists--).

Later when I changed the Top Level (All Departments) to E1 Departments, then I results uploaded correctly 🙂

Attached screenshots for reference.

Thank you so much for the assistance 👍

- Gourav

pic_127396.PNG

Lists_127396.PNG

Quick Links

Can you help?

Unanswered questions

How Can I Recreate Anaplan’s “Reporting Tips & Tricks” Showcase Model for Learning Purposes?
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
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…