Function to Count Booleans

nick_barker

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.

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