How to make a Boolean line item disables other boolean line item

innocent.dike · August 24

Hi Anaplaners,

How can one set up a system where selecting one boolean line item disables the other two boolean line item.

Example:

When you click on Boolean 1, Boolean 2 and Boolean 3 will be disabled (not clickable). Similarly, clicking on Boolean 2 will disable Boolean 1 and Boolean 3, and clicking on Boolean 3 will disable Boolean 1 and Boolean 2.

Thanks

Stacey_Gibbens · August 24

Hi @innocent.dike

I pondered this exact thing several months ago and came up with the following solution! The key is separating the Boolean used by the end-user from the logic that makes up the DCA and a summary method of ANY.

In my instance, the selection is for the module as a whole and not by user, but you could dimension this module by User if needed. My solution is used to identify (by Version) the chosen scenario selected for a planning driver to be used in calculations. Like you, I wanted to have the unselected Booleans in a system module become unavailable if one of the other Booleans is selected.

I have a regular non-numbered list called Scenarios with three members: Default Scenario, Scenario 1, and Scenario 2. I also have a top level called All Scenarios.

My system module has a Selection? Boolean for each Scenario list member. The Selection? line item has the DCA applied based on the Read DCA and Write DCA line items. The Read DCA is TRUE. The Write DCA is calculated based upon the value of another line item called Selection Made? for the Scenarios list top level, All Scenarios. The summary method for Selection Made? line item is ANY - this part is key.

The screenshot below shows the base Boolean R/W status when none are selected. Once any of the Booleans are TRUE then only the one that’s TRUE remains clickable – the rest are read only.