Question about Boolean line items

Scenario

My rows include 3 items - REC1, REC2, and REC3

my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25

Line item - 'Select' which is formatted as Boolean.

Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.

How can I achieve this result?

Best Answer

  • Answer ✓

    Hi @31MB ,
    You can add a DCA to the line item.

    Similar example below-

    When I have REC2 selected, other 2 are disabled.

    DCA R is set to true
    DCA W line item -


    This ensures if nothing is selected then all the lines are open, if something is selected only that is enabled to be deselected.

    Hope this helps! :)

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In