Count line items

edited December 2022 in Modeling



I am looking for a way to count the number of TRUE items for a Boolean formatted line item.

As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the output (it could be in different module as well)

Best Answer

  • @Shraddha0706 


    Create a new line item called Count with the following formula: If Mismatch then 1 else 0


    Put a Top Level on the list in the rows and you will have your total.