4 Replies Latest reply: Feb 28, 2017 8:32 AM by Nicolò Cogno RSS

    Make Row number not respecting set analysis

    Nicolò Cogno

      Hi everybody,

       

      I made a table in this way

       

      Old ObjectOld object PriceNew objectNew object price
      Object 1Price 1Object 2Price 2
      Object 3Price 3Object 4

      Price 4

      Object 5Price 5Object 6Price 6

       

       

      And I did it beacuse I want to have old objects replaced by new objects. When I select the old objects from a filter I can see them in the table with their price and I also select the new objects, but the price that I get isn't correct.

       

      This is the expression that I'm using

       

      Min({<[new_object_code] ={$(=SubField(GetFieldSelections([new_object_code]), ',', RowNo()))}>}[new_object_price])

       

      I'm trying with two different objects and I get the same minimum price of the objects in both the lines and not the minimum price of every object in its line.

       

      What am I doing wrong? "Hard coding" the row nomber gives me the correct results so I think that's the problem

       

      Thanks for your help and for your attention

       

      Best regards

       

      Nicolò Cogno