How does using a module as a filter works?

JosAngel94 · 2023-05-15T14:47:22+00:00

There was an error rendering this rich post.

Lets see if i can explain my self,

I am giving support to a Model which in the UX of the app has filters on top that come from a filter module, they requested me to add a new filter to filter by rep and there is already like 3 filters with that description, but when I add them to the card they don´t work.

Filter Module:

Module to filter:

Is there any documentation I could read on how to use a filter as a module or any Idea how to make this filter work for filtering the REP line item? If more information is required please let me know.

Thanks

Accepted answers

All comments

Venki9902

Hi @JosAngel94 ,

You have already have "view by rep" in you filter module right.
As I can see it has formula, if user wants to select the rep then you can remove and add that line item in your UX page then in your main module you can add one more filter using your filtered module line item("view by rep").

Hope this helps:)

Regards,
Venkatesh

Arnab116

Hi @JosAngel94 ,

In the module to filter, create a line item "Filter" and write a formula having logic where it should be true when either of the conditions will be selected from the filter module.

In your scenario try the formula :

IF (ISBLANK(View By Sales Organisation) OR View By Sales Organisation= Sales Organisation ) AND (ISBLANK(View By status) OR View By Status = Status) THEN TRUE ELSE FALSE.

And use this Filter line item as a filter in the module.

Hope this helps!

Regards,

Arnab

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…