Warning on duplicates

Swarupa_1

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.

 

 

Thanks already for your support.

1635834

@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