AnsweredAssumed Answered

A COUNTIF TYPE OF FUNCTION – THE SAGA CONTINUES TEMPORARILY

Question asked by khank on Oct 27, 2010
Latest reply on Oct 27, 2010 by philmodjunk

Title

A COUNTIF TYPE OF FUNCTION – THE SAGA CONTINUES TEMPORARILY

Post

The solution:

NumList::NumsBase = SeasonNums::MeetNums will only work for your count function in NumList if SeasonNums::MeetNums is a stored, indexed field.

In that case, a calculation field defined in NumList as Count ( SeasonNums::MeetNums ) will return the correct count.

AND THAT WORKS GREAT!

This morning I tried this out on another file to get a better understanding, but this "MeetNums" is a number field with an "Indexed, Auto-enter Calculation replaces existing value" option – and its not working. 

I remembered a key question that was asked: "Is SeasonNums::MeetNums a number field or some kind of calculation field?  If a calculation what is the calculation?"  

What do I need to change to get the "count" to work with a calculation option?

Outcomes