To my knowledge, it is not possible to write a function in the event a turf race is taken off the turf. Could a new filter for surface be developed?

Hi BG,

Not sure what you're trying to do, but if you just want something to flag a raceday surface change, you can use this formula:

#EQUAL($rrTurfB,CDBL(REPLACE(REPLACE(ucase($rrSurfaceS),"D","1"),"T","0")), .00001)

Naturally, you would first have to manually change the surface in ES. I find it easiest to do on the scratch page.

I use a similar formula to record surface changes for my DB.

I'm not aware of any way to flag a PP race change.

W

Thanks for the comeback, Win.

I'm talking about a function calculation in Formula View where, say, I am averaging the highest two Speed Figures (SpeedFig) for Turf races in the last 100 days. Here I use the surface filter as the same as the race in question. However, if the race is taken off the turf, I would like to change the surface to dirt. Manually changing the surface in ES doesn't work. It appears that a new, special filter needs to be set up.

BG,
I now understand that you're talking about the FV race and paceline assignment filters. Maybe Nathan will address them.

Until then, you could accomplish most of what you want by unchecking all of the surface filters and using surface specific FV Variables and Custom Functions....For instance, using your example of averaging the 2 top same surface figs, you could get that fig by using the #hCALCON function.

#hCALCON("ppSpeedFig", "AVG", true, 2, 10, 0, 100, 0, 99, 0, 1, 1, 999, 0, 99) will show the average of the 2 best speed figs within the last 100 days....It will show figs earned on turf if today's race is on the grass, and will only use dirt or aw figs if today's race is taken off the turf. Or using #hCALCON("ppSpeedFig", "AVG", true, 2, 10, 0, 100, 0, 99, 0, 2, 1, 999, 0, 99) will filter it down to turf, dirt, or aw specific figs.

But, if you already knew that, then as Emily Litella (Gilda Radner) would say...."NEVER MIND"!

Good luck, W

I've been away for awhile and would like to make another attempt at what I am getting at. Thanks to Win for replying so far. Win, we are getting close as I am already using a CALCON function calculation almost exactly as you suggest.

However, I don't take my computer to the races. So, I want to make another calculation, earlier, just in case the race is taken off the turf later in the day.

As far as I can tell, switching off the turf designation in ES and using one of the other surface filters won't give me what I want. Hope that makes sense.