I was reading this and on the EXAMPLE section,
there is a IF condition as below;
IF ITEM(Products) = Products.Widget THEN <... calculation for Widget ...> ELSE <... calculation for other products ...>
This made me wonder, does Anaplan automatically compares each items within the list?
In Python term, I am thinking Anaplan is acting as below:
item = ["parent", "code", "widget"]
if "widget" in item: print "it matches!"
Is this correct?
Solved! Go to Solution.
Anaplan doesn't automatically compare (in a literal sense)... so there a recurring need for IF-THEN logic. However, we can say the following:
Does this help?
The python code that you wrote does search the whole list and gives you TRUE OR FALSE with those that have matched.
Whereas, in Anaplan, it goes line by line. Nearly, what python does. However, there are certain limitations to it. Anaplan always does the search line by line. So, if ITEM(PRODUCTS) = Products.Widgets THEN TRUE ELSE FALSE. If your goal is to compare one product or one parent with another product within the list, then you have to employ different methods to it and it varies on the use case.
So to speak, yes Anaplan does search what you have mentioned, line by line. If you are looking for a bulk search then there are workarounds to it. Let me know if there are such use cases that you want help with. I can certainly help you. Post it here and surely I will get back to you.