Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody
I want to have the mode of a field without 0.
This is an example for what i want to have:
Price:
0
0
0
15
16
15
15
0
If i use Mode(price), the result will be 0.
The result that i want will be 15.
I'm awaiting for any help.
Regards
Hi Jeff,
You could try Mode(if(Price <> 0,Price)), and see if you get the result that you are looking for.
Lucas
BizXcel Inc.
Ifs are nasty memory hogs, and should be avoided if possible, especially on large datasets.
I would use set analysis.
=
mode({$<QUANTITY = -{0}>} QUANTITY)
Thanks Lucas,
I try it and it works.
Many Thanks