Return string from field if value meets expectation

[renjithpl]

Hi All,

I have a table like below:

Category	Rating
Pencil	4
Pen	0
Eraser	2

i want to bring the string into a text box, with below condition.

=If(Rating >3, Category)

My output should be. Pencil

This is just a small table, but i have more than 50 Categories.

Please help me. THanks in advance

Ranjit

[Anonymous · Accepted solution]

You shuld use an aggregation function...

try something like that: concat(DISTINCT If(Rating >3, Category))

regards

Matteo

[#3]

Hi!!!

Here, your possible output values count are 0,1 or >1.

and text box can only hold one value. so you have to make your ouput as one value by using concat function.

use below function:

=concat(If(Rating >3, Category),';')

Regards,

Dixit Patel

[renjithpl]

It worked cool, thanks a lot dude..