Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to find the number of the lowest 20% of a field
So the expression I was trying to use was
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
May be like:
Count({< = {'>0 < $(=Max(A)/100*20)' } >} )
Thank you
I forgot about the $