"is first occurence" gives me unwanted output. cant find a solution
my colleagues plan on IDs. After they are finished with their planning I want to build a profit and loss hirarchy by creating codes based on different inputs.
Those codes have to be imported into a list. The problem I am facing now, is that they can plan totally different topics on the same ID in the next forecast. That's why the same code now appears on another ID. The isfirstoccurence formula shows me true, if the exact same code appears somewhere else in another version (HR1, HR2, HR3 are Forecast 1, Forecast 2, etc.)
As you can see in the screenshot, I want the isfirstoccurence to check my column "3.4 ...." the exact same code gives me a true result although I only want true once. I am importing that column into a new list and get the error that this key has already been processed. It seems to be caused by appearing on a new a different ID in another version (once HR3 and once HR1)
How can I combine First Occurence for the list (PV_14, PV_15, .... ) on which my source module is dimensioned on as well as Versions? Any Ideas ?