Reporting on Null

[CSchilling]

Hello!

Here is the formula I created. If you think of a better way please by all means make suggestions!!!

I basically wanted it to tell me if anyone has a null value in the Coverage End Date field to read Active so I can then tell the report to only pull employees with Active health insurance.

Iif ( {PS_HEALTH_BENEFIT.COVERAGE_END_DT} IsNull, Active, {PS_HEALTH_BENEFIT.COVERAGE_END_DT})

I am getting the error of "The ) is missing". I have no idea where it would be missing at though. Do you think iti s a problem that it is a date field? Do I need to convert it to text?

Any help you can provide is much appreciated!

Thank You!

 

[kray4660]

To check for null, it would be in the form: Iif ( isnull({PS_HEALTH_BENEFIT.COVERAGE_END_DT}), Active, {PS_HEALTH_BENEFIT.COVERAGE_END_DT}). I am assuming that Active is a variable that you have created.