SUBSITUTE PRODUCT

Dear Community,

Hope you can help me with this requirement;

1- In fact for a substitution of products, I want to display the first product on each line.

2- I want to display error message on this specific case (but not on the others).

Thank you for your help

Accepted answers

All comments

ChrisAHeathcote

@TAGORTI

1. Create a systems module dimensioned only by product. Add a list formatted line item set to the product list. In the formula bar select the first item from the product list. This will result in Product A being allocated against all products. Reference this in your target module.

2. Add a new line item to your product system module. Format this as the product list too and call it 'New Product'. Populate each entry with the correct product for the corresponding list item. In your target module use the following =IF TargetModule.New Product = ProductSystemModule.New Product then "OK" ELSE "NOK"

TAGORTI

Hello @ChrisAHeathcote,

Thank you for response.

In fact, the module will be like this:

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

- Warning : calculated by formula and displayed

I don't think that your solution respond to the requirement.

Best Regards

MarkWarren

Could you explain the logic a bit, its not clear how either "First Product of the chain" or "Warning" are decided.
Also I recommend using either a boolean or a list formatted line item for "Warning", avoid using text.

TAGORTI

@MarkWarren

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".For the warning, we cannot replace the same product twice, for example we cannot have A replaced by B and G replaced by A.

Thanks

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.…