I've been playing around with set analysis and know there is a way to do this but have so far been unable to figure it out. To simplify my problem, I have three fields, Account, Ratio, Stat. When the user selects an account, I would like to average all the Ratios for the other account numbers where Stat = the value for the selected account Stat.
I would imagine the formula would be something like the following but haven't had much luck so far
Another important thing to note is that Ratio could be 'NA' instead of a number. If it is, I would need the formula to ignore that stat in the average.