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! Go to Solution.
A Percent value is a Decimal value where 0.0
is 0% and 1.0
is 100%.
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%.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |