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.

 

 

 

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! 

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...?

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.