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; } } }

Help Post ---- Import Parent Level data

Sravan_Kumar

Dear Friends,

I am in urgent need, to find the Parent level total in a different module.

But I am unable to do so.

SUM, LOOKUP didn't work mentioning issues.

Kindly help me, I am in really dire need.

Accepted answers

kavinkumar

HI @Sravan_Kumar,

Create another line item with 'List New' as format in 'Module Tests - Copy' module and put this formula. FINDITEM('List New',Prodt Text). Then by using SUM function, try to achieve the data in your target module.

Hope it helps!

All comments

prabhu

@Sravan_Kumar - Don't Use Sum and Lookup, Because you have common dimension.

Just simply **** the formula. it works.

Sravan_Kumar

Hi @prabhu.

Did it work for you if have multiple child?

I tried it, it didn't work for me.

It is returning full total, not total as: L3A, L3B, L3C, L3D, L3E... individually.

It returned total of L3.

Please let me know, if I am wrong.

prabhu

@Sravan_Kumar -

Find the below Screen shot.

Check your dimension and if possible send the screen shot of blueprint and list hierarchy

Sravan_Kumar

Hi @prabhu.

I want the Level 3 total only in the final module.

Please tell me, where I need to edit.

Original Module:

Final Module:

prabhu

@Sravan_Kumar,

You are using different dimension(Which is not a part of Hierarchy dimension in Source Module) in target module.

If you replace the dimension from List New(Flat list) to Level 3 Dimension

it works.

But is it any need of using new Dimension in Target Module...?

kavinkumar

HI @Sravan_Kumar,

Hope it helps!

Sravan_Kumar

Thanks so much @kavinkumar.

It helped.

Sravan_Kumar

Thanks so much friend @prabhu so for your generous help.

My project is needed in that way.

Quick Links

Can you help?

Unanswered questions

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
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…