How to create a boolean with Radio Button like properties?

Options
ShubhamCh
ShubhamCh Member, ALL USERS, Partner Posts: 5 Frequent Contributor
in Planning & Modeling

Hi Everyone,

 

I want to create a boolean line item in a module dimensioned by a list, which can only be true for one list item only at a time.

Let's say, the list has 10 members and initially that boolean is false for every list item. User checks the boolean for list item 2 and then User checks the boolean for list item 5 so after this check, the box of list item 2 should uncheck or become false itself. Only one or none member can be checked at a given time for this line item. Is it possible to create such line item in Anaplan?

Tagged:

Comments

  • JaredDolich
    JaredDolich Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 8

    @ShubhamCh 

    Yep. Just like @ManjunathKN I wish this was possible but that would require the ability to edit both sides of the equation. Anaplan's calculation engine which uses a DAG does not allow us to direct the calculation direction. Anaplan calculates that for us.

    In regards to your use case, one way I have helped users address this is to do the following:

    • Add a filter on your grid that looks for multiple checks. If it exceeds 1 check then filter on the checked boxes. This will tell your user immediately if there's a duplicate check box. Once they fix it, the filter puts the grid back the way it was.
    • Add conditional formatting so it's clear which boxes are checked.
  • JaredDolich
    JaredDolich Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 8

    @ShubhamCh 

    In your system module you can create several Boolean checks. The first will SUM the number of check boxes. So you'll need to add another line item in addition to the check box that converts the check to a one (1). If the sum of that line item is >1 then filter is TRUE. Another Boolean line item will be needed so that if the sum is <=1 then all list items are TRUE. If the sum >1 then only the list items that are checked are TRUE. Then use this filter on your grid.

    You got this! Pretty cool, huh?

  • ShubhamCh
    ShubhamCh Member, ALL USERS, Partner Posts: 5 Frequent Contributor

    @JaredDolich 

     

    What a great idea!! 

    How do I build this filter which gets activated only when there are more than one selection?

  • ShubhamCh
    ShubhamCh Member, ALL USERS, Partner Posts: 5 Frequent Contributor

    Thanks @ryan_kohn for the idea but it won't be practical when there are more than thousands of Activities to select from the drop down, right?

  • ShubhamCh
    ShubhamCh Member, ALL USERS, Partner Posts: 5 Frequent Contributor

    Thanks @JaredDolich for the awesome idea!

    Thanks @ManjunathKN for the detailed implementation steps!

    Kudos to both you👍😊!

  • ManjunathKN
    ManjunathKN Member, ALL USERS, Certified Model Builder Posts: 5

    Hi @ShubhamCh

     

    Very nice thought, I think it is not possible, since your line item is an input, change in value/selection can be done by formula or by import. same line item cannot work like radio button.

     

    Thanks,
    Manjunath

  • ManjunathKN
    ManjunathKN Member, ALL USERS, Certified Model Builder Posts: 5

    @ShubhamCh 

    Thanks for the idea @JaredDolich !

     

    I have shared below on how to achieve that.

    ManjunathKN_0-1663697464845.pngManjunathKN_1-1663697498985.pngManjunathKN_2-1663697537015.png

    Thanks,
    Manjunath

Categories