Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you please attach your QVF file to work on?
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?
Thanks in advance
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?
I need it because I want to specify which of the new objects will replace a specific old object