Need Help on Filtering Data
I have a module containing multiple line items. One of the line item is "org code" with format "Text". I need to filter data based on the values in this line item. "Org code" is actually representing organizations under a department. One department can have multiple org codes. As an example, I am attaching a screen print showing some of the line items of this module.
For the sake of understanding, let's say there are 2 type of org codes -
a.) Normal org codes - Having just the numbers in them e.g. 664401010.
b.) Input org codes - They end with "_Input". e.g. H1_Input
While selecting any department, I should be able to see org codes under it. There are 3 possible scenarios which I have to handle.
Scenario1-
Here I have taken some sample values of Org codes.
664401010 |
660401010 |
680436001 |
615401002 |
In this case, all the values should appear.
Scenario2-
In this case, I have taken following 5 sample values of "org code".
664401010 |
660401010 |
680436001 |
615401002 |
N1_Input |
In this case, I want filters to show all the values except for "N1_Input".
Scenario3-
In this case, I have taken following 4 sample values of "org code".
N1_Input |
N2_Input |
N3_Input |
H1_Input |
In this case, all of the above values should appear.
Basically, the ask here is whenever there are normal org codes then show all of them and whenever we have both i.e. normal as well as Input org codes then only show normal org codes and when we just have Input org codes
then we should show all the Input org codes.
Comments
-
Hi Kamal,
Usman has given a good solution , but just to give a alternative for 1st part where you want to filter out number only.
You can create a new line item with number as format.
in that line item , Put formulas as :
Value(org code) , so wherever there are number in org code , it will get displayed in new line item and text will come as "NaN"
Now you can reference it in the last boolean filter where you want to filter out the respective data.
Hope it helps!!
Ronak
0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways