how to enable a boolean formatted line item when two other boolean formatted line are true. also how to to freeze the two boolean formatted line itme once the enabled boolean line item is true.
Hi @saurav4ss,
You can achieve this using Dynamic Cell Access technique.
Created a line item to check whether 2 booleans are true.
Created another line item to set read and write access for 1st and 2nd boolean.
Let me know if you didn't understand.
Thanks,
Sorna Raja Prabhu
HI @saurav4ss,
This is something that you need to play with Dynamic Cell Access. I have created a few examples for you below.
Expected Result:
Let me know if you have any concerns. I hope this helps.Cheers!
Hi @saurav4ss ,
I haven't wrote a formula for IP3, instead i am using Dynamic Cell Access feature in Anaplan.
IP1, IP2, IP3 are input line items.
Then i have created DCA 3 to check IP1 and IP2 are True.
DCA 3 (Formula) = IP1 and IP2
I am setting DCA 3 as Write Access for IP3. (Which means i am enabling IP3 when IP1 and IP2 are TRUE)
Please replicate the previous message.
You will understand read and write access driver column.
Thank you.
To give a overview of Read and Write Access Column.
Lets say IP3(Boolean Formatted Line item) set as TRUE
Lets say IP4(Boolean Formatted Line item) set as FALSE
and 2 Boolean formatted Line item (IP1, IP2).
Read Access Write Access outcome?
IP1 IP3 IP3 You can See and edit(Read and Write Access Driver are True)
IP2 IP3 IP4 You can only see(Read Access is True) the cell, you cannot edit(Write Access is False).
Read Dynamic Cell Access in Anapedia for detailed information
@prabhu
Got the clear understanding of dynamic cell access. Thanks alot
@kavinkumar
Thanks kavin.
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
