Count line items

Hi,

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)

Accepted answers

rob_marshall

@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.

All comments

rob_marshall

@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.

Shraddha0706

Hi @rob_marshall,

Thank you for the help.

Quick Links

Can you help?

Unanswered questions

Cloud works on UX page
I am unable to see the cloudworks integration on the UX page. Can you advise what I am doing wrong
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…