cmj

Min Non-Empty Calculation

Discussion created by cmj on Aug 18, 2018
Latest reply on Aug 21, 2018 by fmpdude

I thought that the Min function returned the minimum non-empty value of a record. It does not appear to do that.

I have a list of values of which the last one is empty.

Using this calculation I get the result of " " (null) if the Do not evaluate if all ref fields are empty box is checked.

I get the result of " " (null) if the Do not evaluate if all ref fields are empty box is unchecked.

 

Round(Min(Income_YearAmtIndexed_Total_ByYear);2))

I also tried:

not IsEmpty(Round(Min(Income_YearAmtIndexed_Total_ByYear);2))

Using this calculation I get the result of 0 if the Do not evaluate if all ref fields are empty box is checked.

I get the result of 1 if the Do not evaluate if all ref fields are empty box is unchecked.

 

How can I find the min value of a non-empty field?

 

Thanks

Outcomes