8 Replies Latest reply on Aug 23, 2018 10:51 PM by Ankit Agarwal

    Calculate unique values for same row values

    Ankit Agarwal

      Hi,

       

      I mostly find solutions by browsing through the community forum. However I could not find a solution to this problem. Please help as I need this desperately.

       

      Here is what I have

       

          

      Order NoOrder Line NoBookingDesired Result
      11.150005000
      11.15000NULL
      11.120002000
      11.230003000
      11.23000NULL
      11.31200012000
      22.1150150
      22.1150NULL
      22.1250250
      33.1400400
      33.1500

      500

       

      I do not want to blend my data nor create an aggregated filed. I want to create a calculated field which will generate the 'Desired Result' column, which I can use for my other analysis.

       

      Thanks in Advance