In Formula View, I would like to find the maximum purse a horse has raced for. I have tried,
#hMAX("ppPurse", 0, 1000, 0, 50, 0, 0, 10, 0 10000)
but the results are puzzling. Sometime, one or two horses have a value shown,
with the majority of horses having all zeros. Occasionally it's just the opposite,
with all the horses having a value, and only one with zeros. Could someone explain
what's happening here, or suggest another way to get the number I'm after?

Hi Fujimi-cho,

The formula/function you're using is correct. The only thing you need to do is raise the maximum value above the default setting of 10,000....So, #hMAX("ppPurse", 0, 1000, 0, 50, 0, 0, 10, 0 10000000)would even cover the Dubai race .

Good luck, W

The last parameter to #hMAX dictates the maximum value that can be returned. You've got it set to 10,0000. If the purse for a past performance is greater than this, it will be filtered out. Try using a larger value.

Best,
-Nathan

EDIT -- what Win said....

Win & Nathan,
Thanks so much; works like a charm!

Regards,
Fujimi-cho