Hello! How to set value as TRUE based on other line item value

Hi everyone, I'm wondering if someone could help me with this.

I would like create module like picture below.

I have general list "Summary SKU" and "Detail SKU". These general list are not having parent-child hierarchy for each other.

Then, in Line Item "Delete Detail SKU", user will check the Detail SKU they want to delete.

I would like to ask, how can I automatically fill the Line Item "Delete Detail SKU" based on this condition:

If All "Detail SKU Code" that has same "Summary SKU Code" value are all TRUE in "Delete Detail SKU", then "Delete Summary SKU" will also TRUE.

I create visualization like below picture.

Has anyone come across this sort of issue before and how did you manage to resolve it?

Accepted answers

All comments

pyrypeura

You should have list of summary SKUs. There in a module by summary SKU you can check if all of those are true by using formula 'source model'.'delete detail sku'[ALL: 'source model'.'Summary SKU']. Then in the oiriginal module you can take lookup from that source sku model.

rachmitadhila

Hello @pyrypeura, thanks for your reply.

I would like to know more about your answer.

So, I should create another module using Summary SKU as dimension?

And then for the formula, could you please explain more about it?

pyrypeura

Yes you sohuld have another module using Summary SKU as dimension. You can use aggregration method ALL to check that all items with that summary item are true. https://help.anaplan.com/all-c9035c86-1e45-4774-9463-cc5aca76fc7e

rachmitadhila

Hi @pyrypeura,

Thanks for your reply,

I created Module with Summary SKU as dimension.

In this module, I create 3 line items:

Delete Detail SKU?.

In this line item I used Detail SKU as dimension, because the formula refer to the original module that has Detail SKU as dimension too.

2. Summary SKU.

This is List formatted line item.
I used formula: FINDITEM(Summary SKU, CODE(ITEM(Summary SKU)))

3. Delete Summary SKU?.

In this line item, I do not apply other dimension, so it will follow the module dimension which is Summary SKU.
And I tried using formula that you suggested: Delete Detail SKU?[ALL: Summary SKU]

But, the result is I got error message like this: "Level mismatch on common dimension"

Do you know how to resolve this dimension error?

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…