Row condition to filter less than 5 percentage

G_S
Bronze 3
Bronze 3

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.

Solved Solved
0 3 170
1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3

Steve
Platinum 4
Platinum 4

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

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

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

Top Labels in this Space