Skip to Content
0

Help in webi formula

Jun 08, 2017 at 06:40 PM

28

avatar image

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)
10 |10000 characters needed characters left characters exceeded

can you please share the table screenshot?

0

Hi,

Please find the table screenshot above.

Regards,

Dinya

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers