Want to choose a single value

[RishabhTFC]

Hello Guys,

I am facing a  problem. Actually I had this product 111 and I want to use the price value of latest start date but the problem is that there are two similar columns and I want to use only one that is 13.

I am using

FirstSortedValue(Price,-Price_Start_Date)

but it shows me "-" in KPI any suggesstion how can I use it.

Thanks

SG

[olivierrobin]

hello

your 2 prices have the same start date, so you are not sure of the one retrieved by the function

[tresesco]

Try like:

FirstSortedValue(Price,-Price_Start_Date-Price)