How to calculate 'MODE' of child records?
I am curious if there is a way to write a formula that will calculate the Mode of the child records' specific field value. For example, if I have 5 apartments and 2 have the same rent. If I wanted...
Forum Discussion
You would need to hope Dan Dielbolt sees this question as it will need a non native solution.
Yes, I sure hope he does. I mean, I can program the formula itself, logically. I just don't know how to interface it with QB to pull the values of the child records into an array.
Still though, I would have to account for multiple modes (bi-modal?) within my programming.
Hmm. Hope Dan has some insight.
Still though, I would have to account for multiple modes (bi-modal?) within my programming.
Hmm. Hope Dan has some insight.