7 Replies Latest reply on Sep 1, 2016 8:06 AM by David Li

    Identifying duplicate values in a column

    Prasenjeet Acharjee

      Hello,

       

      I am working on a business problem and seeking a solution in this forum.  I have a view as shown below:

       

      Expense Report Number 12756293 for employee id - 21908194 has 6 expense item split no. with the category description and amount in USD. I want to have a coloumn which will say "yes" for every expense item split no. which has the same expense amount and "No" if the amount is not the same. I want the calculation to restart for every Expense report no.

       

      Any help with this will be highly appreciated. Thanks a lot in advance.