Can someone advise me how to compare two lists, one of it being number list ?
Great question. By "compare" I'm assuming you want to find where they intersect and where they don't. In Anaplan two lists can easily be compared, numbered or not, but there has to be a module that relates them together. Here is a quick way to accomplish what you want.
And if the numbered list doesn't have a code it's a bit tricker. You can look up in the non-numbered list but not the other way around.
In the FINDITEM formula will just need to reference the Display Name line item.
One way around no code in non-numbered is to have the module with both lists in it and have a line item that does numbered.display name = non-numbered.name(list) and then use that as a reference point with ANY as summary setting against the list modules.
Really make sure you've got codes in your lists!!
I did the steps until the Boolean part, I`m not sure how to use the formula.
Do you have an example?
So where the numbered list is dimensioned you won't be able to have name(item(list)) as the reference point as that will just return a number. Do you have a display name that you'll be able to use instead.
Then in the check it's a simple isblank(WBS element) formula