Skip to Content

Help in webi formula

Hi Experts,

Could you please check the below table and help me to find and retrive the Duplicate Product Ids with Y and null by default along with other unique row of records.

capture.jpg

I tried the below formula but it brings duplicate productids with checkout value N by defaul along with unique records.

if Previous([Product Id]) = Product Id then "Y" else "N". Moreover it doesnot show Null records for duplicate Product Id's cases,.

Appreciate your help

Regards,

Dinya

capture.jpg (34.5 kB)
capture.jpg (34.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers