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,
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…