FINDITEM formula gives blanks whereas I expect values
Hi Anaplan Community,
I have a strange behaviour in Anaplan.
I use finditem in 4 different line items (Site 1, Site 2, Site 3 and Site 4) . The finditem formula is similar for each line item, it just refers to another text-formatted line item to perform the finditem.
The result of the Site 1 formula looks good. However, Site 2, Site 3 and Site 4 return blanks and I don't understand why. Site 1 is working, so why not the other line items??
Can anyone explain what I am doing wrong?
Attached some print screens for the details on formulas and results.
Next to that some info on what I try to accomplish with this module:
I want to link SKUs to sites manufacturing the SKUs.
I have a source module with the SKU-list and the Site-list as dimensions in which volumes are entered by site leads on SKUs. So wherever there is a volume on a SKU/site combination, I know the site produces that SKU.
I want to summarize that information on SKU-level, so for each SKU I want to mention which sites produce it. That is why I use the TEXTLIST formula to list the sites as text and then I break them back to individual sites.
If anyone has a better idea to accomplish this, please let me know. I am not sure if this is the right approach.
Kind regards, Louise