Level 3 Model Building: Schema Design - Part 2

Hi Team,

Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics
As I am unable to add subset in to the formula.

@jared @Misbah

Accepted answers

KirillKuznetsov

@aniket9917

You have to create this subset with exact name in a Subset tab of Employees list.

After this you will be able to mention it in the formula.

Cheers,

Kirill

KirillKuznetsov

@aniket9917

@muizzsk9890

Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))

All comments

KirillKuznetsov

@aniket9917

You have to create this subset with exact name in a Subset tab of Employees list.

After this you will be able to mention it in the formula.

Cheers,

Kirill

aniket9917

@KirillKuznetsov

I have already tried that way but it is still not working. Is there any other way?

Thanks,

Aniket

KirillKuznetsov

@aniket9917

What error do you get?

muizzsk9890

@KirillKuznetsov @aniket9917

I have also got a similar kind of issue as mentioned in the Snipshot below. It is showing as #E2 Employees active is invalid but since beginning we used E2 Employees#. I have tried both the names for E2 but showing an error. Please help.

Regards,

KirillKuznetsov

@aniket9917

@muizzsk9890

Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))

muizzsk9890

@KirillKuznetsov

Yes, it worked. Thanks a lot for your assistance.

Regards,

KirillKuznetsov

@muizzsk9890Happy to help

@aniket9917How about you?

aniket9917

@KirillKuznetsov

I tried naming convention that you have mentioned & it worked.

Thank you so much.

eramos

Hey Guys , I've the same issue I do not have the option to select the #Emplouees:Active? How do you fixed ? I've tried this formula ISBLANK(FINDITEM('E2 Employees#', Code)) , but without return

Captura de Tela 2024-01-16 às 12.10.09.png

Quick Links

Can you help?

Unanswered questions

Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Anaplan add-in for Power Point security issue
Hello everyone I am going through an issue with security when logging into Anaplan via power point add-in. I am a workspace administrator and SSO user. But once I installed add-in for power point, I am not able to login. I am using Universal Login (default) connection and it asks for user name and then a password (not…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…