Warning on duplicates

Swarupa_1
Occasional Contributor

Warning on duplicates

Dear All,

 

I am trying one use case in Anaplan and it is as mentioned below:

User will input an item in the list formatted line item. If the item is repeating itself then it should highlighted using conditional formatting. It is dimensioned with dummy flat list. Below is the screenshot. 

 

List Item1, List Item2 etc. is a list and Property 1, Property 2 are list formatted line item.

 

Swarupa_1_0-1635854959377.png

 

Thanks already for your support.

1 ACCEPTED SOLUTION

Accepted Solutions
1635834
Contributor

@Swarupa_1 

 

You can use ISFIRSTOCCURENCE() function to identify the duplicates which returns true or false(boolean) and then you can apply conditional formatting for repetitive one's.

Use the link for the function 

 

https://help.anaplan.com/f3a4e998-fda4-42e5-aa48-05bcf6afd852-ISFIRSTOCCURRENCE

View solution in original post

1 REPLY 1
1635834
Contributor

@Swarupa_1 

 

You can use ISFIRSTOCCURENCE() function to identify the duplicates which returns true or false(boolean) and then you can apply conditional formatting for repetitive one's.

Use the link for the function 

 

https://help.anaplan.com/f3a4e998-fda4-42e5-aa48-05bcf6afd852-ISFIRSTOCCURRENCE