1 Reply Latest reply on Apr 26, 2011 5:02 AM by LaRetta_1

    Specify Calculation - Question

    MJWebster

      Title

      Specify Calculation - Question

      Post

      Hello, 

      I have a small calculation for Approx YOB =  Year (Date Enrolled) - Age:

      I have 'ticked' the 'Do not evalute if all referenced fields are empty'.

      However I want the program NOT to evalute if either of the fields are empty.. I am sure that there is a simple way to do this, but I need some help..

      I am using 11.03 on a Mac running 10.6.7 

      Thanks for any help...

      Regards, Malcolm 

        • 1. Re: Specify Calculation - Question
          LaRetta_1

          Hi Malcolm,

          Case (
          Date Enrolled and Age ;
          Year ( Date Enrolled ) - Age
          )

          The Boolean test in blue says:  If there is any number in Date Enrolled AND any number in age, the continue the calculation which comes next.  Otherwise, don't produce a result at all.  Boolean tests produce true (1) if there is a number (anything other than 0 or blank).