asked on March 24, 2020
I have a table column for which I need to get the minimum value. I have this formula. It works; however, I would like it to ignore any empty values until populated.
=MIN(Gravel.Round_Trip_KM)
When a row is added, the value in the new row is empty. This automatically changes the MIN value to zero. Technically, it should do this. I would like to use only populated values to determine the MIN value.
I am overthinking and can't seem to wrap my head around it. Please help.
Also, I would prefer to use formulas and not code for this, if possible.
0
0