However, in an even range, I'd expect the middle two numbers divided by 2, but only the first appears.
Sounds like the expression:
Mode ( Get ( FoundCount ) ; 2 ) // odd number of records in found set
Is not evaluating and thus you never get a true result. It should appear exactly as shown above. Make sure that it's not enclosed in quotes and doesn't look something like this:
//Mode ( Get ( FoundCount ) ; 2 ) // odd number of records in found set
/*Mode ( Get ( FoundCount ) ; 2 ) // odd number of records in found set*/
What you have here should work without issue. No custom functions needed.
Thanks for the help - forgive the thickness, what's the 'If [Mode...' is coming up as an error 'This function cannot be found'.
Should it be 'If [Mod(Get(FoundCount)'?
That's because it's the Modulus function and should be entered as Mod not Mode. The mod function is Ye Olde Long division type "remainder" function.
Sorry, should have seen that typo myself...