Hi Team,
Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced TopicsAs I am unable to add subset in to the formula.
@jared @Misbah
@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
@muizzsk9890
Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))
@KirillKuznetsov
I have already tried that way but it is still not working. Is there any other way?
Thanks,
Aniket
What error do you get?
@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,
Yes, it worked. Thanks a lot for your assistance.
@muizzsk9890Happy to help
@aniket9917How about you?
I tried naming convention that you have mentioned & it worked.
Thank you so much.
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
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
I am still now to the calculation of Anaplan XL, i would like to get the proportion in terms of value between child vs parent (within the hierarchy) For instance, i want to get the % of each 08S( child) vs the parent value (BL TS), i would like IN general a formula that give the proportion of child vs parent dynamically,…
Just like the main question above, I wanted to try out the new feature on the board where you can you the insights panel to put additional cards. However, I wanted to synchronize scroll a card on the main board with the card on the insights panel but I can't find where it might be.