Ben Ball Posted January 24, 2007 Posted January 24, 2007 I have a calculation field = X - Y I have checked the box for: "do not evaluate if all reference fields are empty" However the field will still calculate if only one field is entered with a value. How can I stop the calc working if only one field is entered? Ben
IdealData Posted January 24, 2007 Posted January 24, 2007 How about Case (IsEmpty (X) OR IsEmpty(Y); ""; X - Y)
Ben Ball Posted January 24, 2007 Author Posted January 24, 2007 Ummm as easy as that... Thanks works perfect.
Recommended Posts
This topic is 6574 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now