Hi Members,
I am adding formulas to the properties, I am thrown this error.
The actual output (mentioned as output in pic) is shown.
Please assist me with the correction, that needs to be done.
Regards,
Sravan.
hi @Sravan_Kumar
I have noticed a couple of issues in the attached pics:
1. in your "SS 4" pic, I have noticed that you are trying to use a different list in the FINDITEM formula:
As you can see, you are working with LIST "ABC. Order Quantities Patent" whereas in your formula your are trying to use the codes from the list "Order Quantities Parent". Even if both lists have the same items, both lists are not related to each other for Anaplan, therefore you cannot use the code from a 3rd list for this purpose.
In other words: you can only use name, code or properties of the list where you are trying to implement the FINDITEM function (or module where that list applies).
2. Then you are trying to use CODE to Find items from "ABC L2 Brand", whereas you do not have CODE in your list "ABC, Order Quantities Parent" (as per pic "SS 3").
So, my first suggestion for you would be to replace CODE by NAME in your formula at "ABC. Order Quantities Parent", since names on both lists seem to be the same. Otherwise, make sure that the items from both lists have the same codes. Id est, replace the underlined formula by this one: FINDITEM('ABC. L2 Brand',NAME(item('ABC. Order Quantities Parent')))
Else, apply the same formula as per your pictures in list "Order Quantities Parent" instead of "ABC. Order Quantities Parent".
Please, let me know if it works.
Alex.
Olivehorse
Thanks Alex for the help.
I corrected it, it worked.
Thanks for letting me know that it helped! I am happy to hear it.
Cheers,
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
