Skip to main content
Solved

How do i get a rollup with formula Min()to stop returning zero when rolling up empty cells?


Forum|alt.badge.img+13

In [Workers] I have a rollup field called {Lowest_rating} which uses the Min() formula to return the lowest number a worker has in [Worker Interactions]. FWIW, the field in [Worker Interactions] that is being rolled-up is a number field.

Where the worker has no rating yet, the rollup returns a “0”. I find this to be visually confusing. Is there anyway in the rollup to return the cell empty rather than a zero? Photos below.

thanks!

Best answer by Kamille_Parks11

Try: IF(values, MIN(values))

View original
Did this topic help you find an answer to your question?

2 replies

Kamille_Parks11
Forum|alt.badge.img+25

Try: IF(values, MIN(values))


Forum|alt.badge.img+13
  • Author
  • Inspiring
  • 40 replies
  • March 1, 2021
Kamille_Parks11 wrote:

Try: IF(values, MIN(values))


Awesome. Thank you, Kamille!


Reply