3 Replies Latest reply: Jul 18, 2013 12:25 PM by Cameron Scully RSS

    Find minimum value based on minimum date per line

    Cameron Scully

      I have a straight table of orders. For each order there is a series of changes in a seperate file. I want to show the minimum quantity change for the minimum change date in the change file. The table's primary dimension is the order number, which is the key.

       

      min({$<OCD={$(=min(OCD))}>}OldQty)

       

      -where OCD is the change date in a numeric form-

       

      This Expression works only sometimes and mostly gives null. But if I select a specific order number it works fine. It doesn't make sense to me since there is only one order number and it is the dimension for the chart. Am I missing something in the set analysis?