Make Row number not respecting set analysis

[#1]

Hi everybody,

I made a table in this way

Old Object	Old object Price	New object	New object price
Object 1	Price 1	Object 2	Price 2
Object 3	Price 3	Object 4	Price 4
Object 5	Price 5	Object 6	Price 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

[OmarBenSalem]

Can you please attach your QVF file to work on?

[#3]

Hi,

I'm sorry, but I really can't. I think that the problem is that Rowno() is giving me the wrong number of the row, the set analysis is being applied on it too.

Do you have any suggestion?

stalwar1‌

Thanks in advance

[sunny_talwar]

Not sure I understand the purpose of set analysis here.... why do you need this?

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

If you have New object as dimension, then why not just Min([new_object_price]) as expression?

[#5]

I need it because I want to specify which of the new objects will replace a specific old object 

Replace components one by one