17
Views
4
###### How to find the lowest Average Table Column value from multiple tables Columns
Question

i have 5 tables representing 5 rounds of golf, each table will be poulated on a different day (e.g. round1 = Day1.  round2 = Day2 and so on) with player scores.  i have an aggregate for each day that works out the Day average (Total/players) eg, 16 players score 33 points Total each = Day average 33.

i need to write an Expression to find the lowest Average score from the 5 Rounds Average scores.

i have tried nesting IF() statements but because an IF() statements stops when a condition is met.   If the following day Average is lower, the next IF() statement doesnt work

topology.PNG Laura Fidalgo

Hey Jolly,

Have you tried the Min() numeric function, under built in functions? You can use it on an expression, and you can also nest it.

Hope this helps!

Laura Jolly Boys

Hi Laura,

i didnt think about using that function as it only takes 2 values.  however, i have nested the Min() values and it works a treat if all averages (5 days) are populated.  if the scores are not added to a day the average returned for that day is zero which is what the expression returns, problem i now have is i only want the Min() value if its above zero.

any ideas what i need to do? Laura Fidalgo

Hi Jolly, 