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.
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!
@Sravan_Kumar - Don't Use Sum and Lookup, Because you have common dimension.
Just simply **** the formula. it works.
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.
@Sravan_Kumar -
Find the below Screen shot.
Check your dimension and if possible send the screen shot of blueprint and list hierarchy
I want the Level 3 total only in the final module.
Please tell me, where I need to edit.
Original Module:
Final Module:
@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...?
Thanks so much @kavinkumar.
It helped.
Thanks so much friend @prabhu so for your generous help.
My project is needed in that way.
Hi Team, I have been trying to apply a sort based on a column in one of the combined grids and seems like the option is disabled. Does anyone has any idea on this? Regards, Aakash Sachdeva
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
