How to select only one Boolean line item at a time by disabling all other Boolean options?

I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.

Screenshot 2024-02-22 081823.png

Accepted answers

HimanshuRaj

You can use this formula in Write DCA Line Item,

You don't need any summary for Only One? Line Item and use this formula:

IF TIMESUM(Only One?) THEN Only One? ELSE TRUE

Cheers!!

All comments

SriNitya

@jhondoe443322
By using Dynamic Cell access you can implement this.

jhondoe443322

@SriNitya Can you guide me. I am not able to do this I have tried

HimanshuRaj

@jhondoe443322 Use below logic to apply DCA

Please Note the Line Item Summary for Only One

Cheers!!

jhondoe443322

@HimanshuRaj is there a way where we can possibly avoid SELECT actually there is no LIST or anything available for me the Only one Boolean Line Item is Time Formatted and I cannot use SELECT there!

HimanshuRaj

@jhondoe443322 If it's time formatted, then keep the time summary to Any as i did above and use [Select: Time.All Periods]. It will work same way

Can you confirm, if you have Total of All Periods on in your time settings

jhondoe443322

Yes I have tried the approach you are telling. But I want to avoid the use of SELECT and All Periods!

HimanshuRaj

Is there any specific reason to avoid using Select for All Periods? as It's not against Planual Best Practices

HimanshuRaj

You can use this formula in Write DCA Line Item,

You don't need any summary for Only One? Line Item and use this formula:

IF TIMESUM(Only One?) THEN Only One? ELSE TRUE

Cheers!!

HiteshPatil

To avoid select you can try below approach,
Create below two modules.
1.

HiteshPatil

To avoid select you can try below approach,
Create below two modules.
1.

HiteshPatil

@jhondoe443322 To avoid select you can also try below approach,
Create below two modules.

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385