If condition to get decimal values between o to -1

we dont know your details, but give a try at and use it within the If as a condition

CDbl(CurrentRow("Variance").ToString.Trim) < 0

Analysis and prototyping can be done with: