Function to Count Booleans

There are occasions in a model where I want to count the number of True or False boolean values. Currently the only way to achieve this is to have another line item with an IF THEN function to create a 1 or 0 and then sum the line item. It would be great to have a function to do this automatically.

Comments

Miran

Status changed to: New

MirBorishkevich

Seems like a simple win which would enhance the best line item format!

Stacey_Gibbens

Yes, it would also help by reducing model size, since we wouldn't need to add additional line items just to count a Boolean!!

I hope this concept would get some attention. :)

SHARMARATNESH2

@nick_barker @Stacey_Gibbens @MirBorishkevich @Miran

I have a solution here:

Keep the format of the target line item as "Number". Then use the IF Boolean THEN 1 ELSE 0 starting from Opening bracket "(" and ending with closing bracket ")". Use + sign after each boolean. All these booleans can be counted and summed in 1 formula . Check Images for reference:

nick_barker

Hi yes that works however it gives you the potential for a horrible IF THEN clause if you are checking lots of Booleans as in your example. In reality counting booleans is normally to allow you to do conditional formatting and I think there are other ideas out there to allow you to just apply a CF directly to a Boolean line item.

SHARMARATNESH2

As long as, there is no other solution anywhere. This works!! This is not a case of nested IF THEN and hence, there is no impact on the performance

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…