Replacement Chain

Dear Community,

Hope you can help me with this requirement;

1- In fact, we have a list of products and we want to replace it for example:

We have : A replaced by B then B replaced by C and C replaced by D what makes a chain of substitution A-B-C-D. What I want to display on each line is the first product of the chain in our case "A"

N.B :

- New Product : enterable by User

- First Product of the chain : calculated by formula and displayed

- Warning : calculated by formula and displayed

2- I want to display error message on this specific case (we cannot replace the same product twice, for example we cannot have A replaced by B and G replaced by A.).

Thank you for your help

Accepted answers

All comments

KirillKuznetsov

@TAGORTII just stuck with your warning message. Do i understand correctly that the order of the list members matters in calculation? I can see in your example that error message is only against "I" because NEW PRODUCT mentionned there is "G". And "G" stays prior to "I". I am asking because if we ignore the error, then the chain will look like this: I-G-J, which can be calculated as FIRST PRODUCT OF THE CHAIN = "I".

Or this means that error appears only if any product mentionned more that once?

If this is actually the case then you have to concider the above in your calculation.

TAGORTI

Hello @KirillKuznetsov ,

Thank you for your reply.

In fact the order doesn't matter, the error must appear when an old product (already substituted) is used as a new product for another product.

Regards,

KirillKuznetsov

In this case B and C also follow this rule and must be NOK. At least this is what I see on your screenshot. Could you comment on that?

TAGORTI

@KirillKuznetsov

In the first case is as follows : A-B-C-D so no error.
In the second case : E-F and G-E so the chain will be G-E-F this is an error on the second line.

KirillKuznetsov

I don't see any difference, but the order in which the new products are assigned and only in case if the order of the products matches with the order of new products being assigned

KirillKuznetsov

Another question. Do these new products have to appear only once in the line item?

TAGORTI

The order of the new product assignment and the occurrence of the new products differs from the first case.
If I already substituted a product i cannot used as a new product.
Did you find a solution for the first part of the requirement ?

Thanks

TAGORTI

yes one time

KirillKuznetsov

Do you know the maximum length of such chain?

TAGORTI

@KirillKuznetsov I think the maximum should be at 40-50

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…