Module line item formula not working

praba71

I am trying a simple formula to populate the line item 'Destination Org (Source)' in my module 'Comp Incoming PR/PO'.

The formula is comp_pro_po_supply.Destination Org.

Any help is appreciated.

Thanks

Regards

Prabakaran

Screenshot_2020-05-31_at_8_72208.png

Accepted answers

einas.ibrahim

Hi @praba71

I am not 100% sure I understand your ask or where the problem lies, but I do have a question for you that may help you think about this.

You are using a numbered list where you have the display name set to -14 for all list items, why?

Also, you are using list properties, you should avoid doing so and instead create a System module dimensioned by the comp_pro_po_supply list and store these properties in the module. You can later access the properties much easier.

emmaliao

Hi @praba71 ,

The source 'Destination Org' is a list property of the 'comp_pro_po_supply" list, however, the target module 'Comp Incoming PR/PO' is using a different list ('svr_pro_po_supply") as its dimension. Since the source and target dimension don't match, your formula won't work unless there is a linkage/relationship between the two.

What is the relationship between the two lists? We can create a list property to establish the mapping of the two lists and then use a lookup formula to populate the line item 'Destination Org (Source)' .

All comments

einas.ibrahim

emmaliao

Hi @praba71 ,

praba71

Thanks @einas.ibrahim for the response. I have corrected the formula for the Display name. The formula now is Requisition Number & "-" & TEXT(Req Line Number) . It is showing correct values now,

Also, you mention about creating a system module dimensioned by the list comp_pro_po_supply . Can you please provide more details on how to do this?

Thanks again

Prabakaran

praba71

Hi @einas.ibrahim , i got the issue fixed.. Thanks again

Regards

Prabakaran

praba71

Hi @emmaliao , I got the issue fixed by correcting the dimension of the module.. Thanks

Regards

Prabakaran

einas.ibrahim

Hi @praba71

I'm glad you got the formula to work.

System modules are created to adhere to Best Practice.
One type of these system modules is modules to hold list properties instead of actually using list properties. We are moving away from using list properties.

If you haven't yet, please read the Planual as a guide to Best Practice.

Also, this post by @Misbah will give you more details on the how and why we should use System modules for lists.

Kanishq17

hi @praba71

the module in which you are trying to refer the formula applies to a different dimension than the source list you are taking values from,

you need to establish mapping between both lists via a module or property in the target dimension or you need to change dimension to the same list that you are referring the property from

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
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.…
AnaplanXL Difficulties
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…
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.…