Production list item protection

Options
ethancomstock@gmail.com
ethancomstock@gmail.com Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
in Enterprise Scale

Hello,

 

We are in the final stages of an implementation and are running into issues related to marking lists as production data.  The problem is that over the course of development many list items have been referenced in line item formulas, so the system prevents these lists from becoming production data.  The workarounds suggested in other community posts, such as using LOOKUP instead of SELECT, have not worked.  If anyone has any experience with this problem or suggestions I would greatly appreciate any help.

 

Thank you,

Ethan

Tagged:

Comments

  • ethancomstock@gmail.com
    ethancomstock@gmail.com Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    Thank you for the feedback.  Do you know if using the PARENT function on a list will prevent marking it as production data?

  • ethancomstock@gmail.com
    ethancomstock@gmail.com Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    How about FINDITEM?

  • YuliaL
    YuliaL Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Hi! I am using this extra module with list-dimensioned Line item to reference a Production list. But I need to reference the item on Level 1, and the list is hierarchical with no Top Level Item. Like for example, we have Germany (level 0) and France (level 0) but I need to reference Europe (level 1). The formula works but gives 0 as a result. Do you have any ideas how to deal with such a case?

  • YuliaL
    YuliaL Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Thanks David, after your comment I've realised that we have exactly this module to build flat hierarchy for other things. So I used that hierarchy instead and it worked fine:).

Categories