Filter Single Value

[Anonymous]

Hi guys,

         I have this situation, I've an input textfield where I can write the year and an output textfield where I wuold show a price.

Normally I could write inside the output textfield:

     =sum({<year = {$(vYearIn)}>}value)

in this way a can have only the values about a specific year, but in this case I need to take a single value, and not a sum of values, and

I can't replace input textfield with listbox.

How can I select a single value with only this two object?

Thanks

[greend21]

Did you try Num instead of Sum?

[vishsaggi]

Can you elaborate with some sample data? Textfield you mean textbox or inputfield object?

[prieper]

Did you ever try to input 2016,2017 for two years?

edit: attached example

[Anonymous]

I did, but it doesn't work

[Anonymous]

A little example attached.

Inside the blue box I would read the price about the year that I wrote inside the inputfield

[vishsaggi · Accepted solution]

Try this in your blue box?

= Only( {< year = {$(vYearIn)} >} price)

[Anonymous]

Thanks