Skip to main content
Solved

Minimum Value Exclude 0

  • August 12, 2020
  • 6 replies
  • 45 views

I want to get minimum value in a cell however I want to exclude 0.

Best answer by ScottWorld

Hi, yes the $0 is important because we field that auto generate value in that area.
Just want to ask how to filter out $0 if I create new field? I can’t determine.


Create a conditional lookup:

6 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • August 12, 2020

My first instinct on how to solve this would be:

Do you really need to see all those $0.00 values in your lookup field? Is it important to you to see all of those $0.00 values?

If not, just modify your lookup field to become a conditional lookup field by filtering out any records that have $0 as their value.


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • August 12, 2020

My first instinct on how to solve this would be:

Do you really need to see all those $0.00 values in your lookup field? Is it important to you to see all of those $0.00 values?

If not, just modify your lookup field to become a conditional lookup field by filtering out any records that have $0 as their value.


Oh, and I should add:

If seeing all those $0.00 values IS important to you, then I think the easiest way to solve this would be to simply create ANOTHER lookup field where you conditionally filter out the $0.00 values, and then base your formula on THAT lookup field instead. You can also hide that additional lookup field so you don’t need to see it.


  • Author
  • New Participant
  • August 12, 2020

Oh, and I should add:

If seeing all those $0.00 values IS important to you, then I think the easiest way to solve this would be to simply create ANOTHER lookup field where you conditionally filter out the $0.00 values, and then base your formula on THAT lookup field instead. You can also hide that additional lookup field so you don’t need to see it.


Hi, yes the $0 is important because we field that auto generate value in that area.
Just want to ask how to filter out $0 if I create new field? I can’t determine.


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • August 12, 2020

Hi, yes the $0 is important because we field that auto generate value in that area.
Just want to ask how to filter out $0 if I create new field? I can’t determine.


Create a conditional lookup:


  • Author
  • New Participant
  • August 14, 2020

Create a conditional lookup:


Thank you for your idea. I already get the output I need.
I used rollup and add condition not equal to = 0.


  • Author
  • New Participant
  • August 14, 2020