Conditional Formatting for Duplicate List-Formatted Line Item

rrist

Feels like I'm missing a simple idea. I have a module dimensioned by line items and list A.

One line item is formatted as list B. Users select corresponding list B for each list A.

What logic in a CF line item can call out if duplicate list Bs have been selected?

Accepted answers

Dikshant

@rrist - This is what you wanted, right?

This is how I've done it. I have first created a count line item with formula as 1. Then I go to Order Module and create a line item (Total) and sum up the count based on Orders. I will give you the number of times it is repeated. Then write the condition to your CF, looking up the count based on Order and If it's greater than 1 then it should be a RED else WHITE.

All comments

Dikshant

If you want to highlight the second line with duplicate selection, then you can use ISFIRSTOCCURRENCE, as it will give a true for all first occurrences, and all 2nd 3rd multiple occurrences you can highlight them as Red.

But if you want to highlight both, then you can use SUM Function to get the count of selections. If it is greater than 1 then highlight all occurrences.

rrist

@Dikshant Thank you, I had tried both of those functions. Something with dimensionality is throwing me off.

The goal is to have 'Order' cells be highlighted if a duplicate has been selected. However, the module is dimensioned by another list.

sobaidps

Hi @rrist , as dikshant asked about the condition for the format, how you want to highlight

do you want to include the first selected entry value as well in

rrist

Hi @sobaidps, the goal would be to highlight both the first and second entry

Dikshant

@rrist - This is what you wanted, right?

rrist

@Dikshant exactly it, thank you

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385