Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Setting limits without hard values

Hello

I am trying to find the number of the lowest 20% of a field

So the expression I was trying to use was

--- Field Name

Count({< = {'>0<({Max(A)/100*20})'} >} )

Instead of the expression with hard values which does work

Count({< = {'>0<20'} >} )

My idea was that even if more values were added it would still count the lowest 20% of values

If there is a way to correct advise would be appreciated

Thank you

1 Solution

Accepted Solutions
2 Replies
tresesco
MVP
MVP

Anonymous
Not applicable
Author

Thank you

I forgot about the $