Hey Nathan,

Basic question is:
In the upcoming Formula View, will I be able to query two different Columns and put the results into a third column?

Trying to come up with a "formula/expression" that shows me at a glance which pacelines in a horse's pps match today's projected pace. If I set the projected pace of the race at 92, I want there to be either a "1" or "0" (could be a "Y" or "N" as well) after each pace line in a horse's PPs who's POR rating (this is the rating you helped me create about a week ago) is 92 or higher and finished within 5 lengths of the winner. I would have to edit this formula for each race since the projected pace will always be different. The formula would have to query the POR column to see if it was 92 or higher, and then query the Final Lengths Behind column to see if it was less than 6. If both conditions where meet, the third coloumn would indicate "Yes" with a "1" or "Y". Or a "0" or "N" would be displayed in the third column if both conditions were not met.

Hopefully my question makes sense to you...and imagine the beauty of being able to see at a glance, which horses have recently or in the past, been competitive against today's probable pace.

KevinKD

You won't be able to get the value from two different columns to use in the expression for a third column -- although, thinking about it now, I can probably add this easily.

Irregardless, you could do what you want easily in an expression that didn't reference any other columns. Something like:

GREATER(FormulaForPOR, 92) * LESSER(BtnLengths, 6)

That is, if both equal 1, the result is 1, otherwise,if either is 0, the result in the column is zero.

So would that expression need to look something like this:
GREATER($ppE2 + (2 * $ppBtnLenghts2),92)*LESSER(BtnLengths,6)

I know you talked about the ability to share FV Templates with each other once the program is released...it might also be fruitful to start an "Expressions" FAQ page of sorts...I'm sure it wouldn't take more than a month or two to get all the basic expressions listed with everyone sharing.

Another quick question...will we be able to FORMAT the Number's STYLE in each column like in Excel? Might it be possible to have numbers go 3 decimal points (.756) in one column, 2 decimal points (5.75)in a second column and a general number (2)in a third column?

Thanks again for your insights...

KevinKD

Kevin,

I think that you've got the gist of it.

You won't be able to format numbers in this version. Every number will have two decimal places.