AnsweredAssumed Answered

Going To Another Field If Blank

Question asked by CraigBarnes on Aug 28, 2011
Latest reply on Aug 28, 2011 by CraigBarnes

Title

Going To Another Field If Blank

Post

I have 15 fields for alculating times, each building on the previous and that works good. But, all of the fields may not be used, sometimes maybe on the first 4 or 6 fields. How would I make the calculation stop if the previous field was empty and go to a specified field?

An example would be the first 5 are used and have times in them, the 5th field is blank so the DEP field needs to calculate the time from field 5.

5 Timepoints

The calculation that I have written works for the current field, but not on the follwing fields.

7 Timepoints

Thanks for any help and/or comments.

Craig

Outcomes