Row condition to filter less than 5 percentage

I am having table strength,
In this table I have three column behaviour and priority
Behaviour column type text
Priority column type percent
In need to select the behaviour column which is less than 5 %
Can anyone help me with the formula.

What have you tried? How do you think it should be done?

1 Like

I tried with the formula
Select (table name[behaviour],[priority]<5).

1 Like

A Percent value is a Decimal value where 0.0 is 0% and 1.0 is 100%.

1 Like