show a value in a text box

[sylvain_piccarreta]

Hello,

I would like to show in a text box a specific value.
I have a table :

Items	Number
Bread	567
Milk	23
Sugar	234

A in a text box, I would like to have 'Sugar : 234 ' even if I selected other thing.

Thanks for your help,

Regards,

Sylvain

[sergio0592]

Hi,

If yout try with:

=sum({<Items={'Sugar'}>} Number)

[sylvain_piccarreta]

thanks for your help but my example was not clear, because, it's not a quantity but it's an ID with some alphanumeric.

Items	Number
Bread	567Ab
Milk	23D
Sugar	234ED34

[sergio0592 · Accepted solution]

Ok, try with:

=Only({<Items={'Sugar'}>} Number)

[sylvain_piccarreta]

thanks, it's great