Kindly help me to understand how I can achieve this?

meshivam

I have two modules. In the first module, when I select "America," its child fields should become editable. If I change the value of any child field from zero to a non-zero value, all other child fields under "America" should become non-editable, except for the one I modified. If I revert that value back to zero, all child fields under "America" should become editable again. How can I achieve this ? ,Kindly help me to understand. @seymatas1 @rob_marshall

matheus.azevedo

Hi @meshivam

I believe this logic can solve your problem:

1. First, create a Boolean to serve as the DCA for the Sales line item. Here, I named it DCA - Sales.
2. In the screenshot, I created the line items Item: R2 Country (formatted as list) and Parent: R1 Region (also formatted as list) in the same module DAT001, but I recommend creating them in a SYS module dimensioned by the R2 Country list, as this follows best practices.
3. Apply the formula in the DCA - Sales line item:

'REG001 Region selection'.Boolean[LOOKUP: 'Parent: R1 Region'] AND (Sales[LOOKUP: 'Parent: R1 Region'] = 0 OR Sales <> 0)

4. Apply the DCA - Sales as a Write Access for Sales line item in the blueprint view.

Outcome:

Let me know if it worked.