Count line items

Shraddha0706
Shraddha0706
edited December 2022 in Modeling

Hi, 

 

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

Shraddha0706_1-1671478762220.png
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)

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    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.

Answers

Categories