How to calculate Mode() without 0

[#1]

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

[lblancher]

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.

[#3]

Ifs are nasty memory hogs, and should be avoided if possible, especially on large datasets.

I would use set analysis.

=
mode({$<QUANTITY = -{0}>} QUANTITY)

[#4]

Thanks Lucas,

I try it and it works.

Many Thanks