Maximum Function to Exclude Zero

I have a formula in my running total that will obtain the maximum value out of the listing.
Sometimes, the only value is a zero. Is there a way I can write the formula to still obtain the maximum value and in cases where the only value is a zero, to exclude it?
metalteckAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
WHat calculations do you need them excluded from?
FOr instance a SUM would not be affected by the 0 value.  

Is 0 never a legitimate value?

Can values be negative?

If you are concerned about them being part of the maximum calculation then use a formula like

If {Field} = 0 then
    -99999999999
Else
    {Field}

When you take the Maximum of that formula, you can test it to see if the max is -99999999999 and not display it.

mlmcc
0
 
mlmccCommented:
I am not sure what you are trying to do?

Why do you need to ignore the 0 values?

mlmcc
0
 
James0628Commented:
Exclude it from what?  The report (ie. don't display it), or don't include it in some calculation, or ...?

 James
0
 
metalteckAuthor Commented:
The zero values are not needed in the report, but unfortunately, some values have 0. I need them to be excluded from the calculation.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.