You are viewing limited content. For full access, please sign in.

Question

Question

Exclude empty row from calculation

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

Replies

replied on March 25, 2020

There is no out of box MINIF formula supported so currently not doable with formulas.

0 0
replied on March 26, 2020

Can anyone tell me if this can be done by coding? If so, please explain what I need to do. I am not an experienced coder.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.