Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
4 years ago

Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table

Hi QB Community, I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table.   I start with this: GetFieldValues(GetRecords("{249.EX....
formula queries
EdwardHefter's avatar
EdwardHefter
Qrew Cadet
3 years ago

Thanks - I had seen that before and her videos have been extremely helpful to me! I am trying to find the highest value. I can rank them, but if I have 2 records in "first place," I can't do a "sumvalues" to find the highest number.

I might be able to do a sumvalue of the highest ranking and then divide by the number of records, though. I'll give that a try tomorrow.



------------------------------
Edward Hefter
www.Sutubra.com
------------------------------