14 Replies Latest reply: Jan 11, 2014 4:00 AM by Manish Kachhia RSS

    FirstSortedValue

    Manish Kachhia

      Dimension

      PartNumber

       

      Expression

      FirstSortedValue(Price,-InvoiceDate)

       

      1) Giving me '-' whenever same part number is sold more than once on the same date.

      2) What if same part number is sold more than once with different price

       

      My Idea is to get Minimum Price for each part number sold on the latest Date...