Not calculating blank field

[Former Community Member]

I have a column with 10 fields in it. I have another field at the bottom which is looking at the 10 above. It will pull the smallest value from the 10 using "MIN".



My problem is, if one of the 10 fields is left blank, then the "MIN" field below is reading that as zero and entering that as the smallest value.



How do I have the "MIN" value field over look the blank fields and just pull from what is entered?



Thank you in advance

[Former Community Member]

I'm unable to duplicate the problem you're having. I created a blank form with 11 numeric fields on it and if I leave one of them blank, it still takes the lowest number from the fields I placed values in. I named the fields n1-n11, here's the formcalc script I used.



this.rawValue = Min(n1,n2,n3,n4,n5,n6,n7,n8,n9,n10)



Could you post the script you're using?



Regards,

Dave