Conditional Boolean: True if an item in Source Module belongs to an intersection in another module

Hi Community!

I would like to create a boolean that is TRUE when an item with List format in the source module A currently has an "active intersection" in another module B.

So for example, I have a list of Accounts. These accounts have a correspondent Activity related to it (specified in the module .

I also have a published process (NUX) that updates the Accounts List. Therefore, when the User updates the list items, the dropdown in Module B changes accordingly (also published). The thing is, I don't want that process to eliminate nor change those Accounts currently belonging to an Activity. So I thought of creating this boolean that is TRUE when an Account has an "intersection" with this Activity line item in Module B (I called it "Active Account?")

Then I thought of creating a Saved View to then import to the Accounts List conditional on this boolean...

Is this approach correct? Is it possible?

The request basically is: Is it possible to retain data if currently used?

Thanks in advance! I'm new to Anaplan so appreciate your insight.

Accepted answers

All comments

JaredDolich

@CarAmbrosano

Can you use FINDITEM?

ShubhamCh

Hi @CarAmbrosano

First let me explain my understanding of your problem:-

One List - Account
One module dimensioned by another list which has one line item as Account List formatted
You have one process in your app which updates Account List, means it adds new list items to this list so the dropdown shows new Accounts after the process runs.
You want to create another module dimensioned by Accounts where you want one boolean to be true if the corresponding account is selected in one of the dropdown in the other module, right?

Confirm if I understand your problem correctly or correct me if I missed some points. I'll write the solution after I am sure about description of the problem.

Thanks!

- Shubham

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…