function to tell calculation to exclude empty fields?

[AlanP]

Good morning,

I tried a few ways to do this but with no luck...is there a way to add to this calculation that will tell it that if field "TEST ISSUED DATE" has nothing in it (blank), that is should exclude those records?

Here is the code I'm using:

Case ( Get (CurrentDate) > CALC TEST DUE DATE and IsEmpty ( CALC TEST RECEIVED );"ALERT" )

Basically the calculation is working perfect (thanks to everyone who helped http://fmforums.com/forum/showtopic.php?fid/31/tid/168288/pid/169414/post/last/#LAST ), however it's also showing results from employees who we have not given tests to yet.

Hope that made sense and thank you!

Also does anyone know if there is a thread, book or website that talks about what all the functions, operators, etc. mean and do when you create calculations? I'd like to learn more about them!

[SlimJim]

Good morning,

if field "TEST ISSUED DATE" has nothing in it (blank), that is should exclude those records?

As you have already used a Case you could just add in the extra case condition at the front:

Case (IsEmpty(TEST ISSUED DATE);"";Get (CurrentDate) > CALC TEST DUE DATE and IsEmpty ( CALC TEST RECEIVED );"ALERT" )

Put whatever result you want instead of "".

[AlanP]

cool beans! thanks slim jim! :o