IsNull Formula

[Jason2121]

I am trying to create a Fromula to represent all employees still on board after 12/31/2009 to show what the yearly cost would be for each Department. Here is what I have so far;

IsNull// If {V_PLSEE.PL_TERMINATE_DT} < {?Enter Date}

I am getting a alert stating that I do not have enough arguments in my Formula. I have employee name and number in my Reeport along with Enter Date in my Parameters.

Can anyone help or point me in the right direction?

Thanks

 

[HowardHammerman]

You either have to provide the THEN part of the operator or just eliminate the IF to create a boolean (true/false).

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Jason2121]

I used this and it worked to eliminate any employees thata re no longer on Staff after a Parameter Date selected.

IsNull ({V_PLSEE.PL_TERMINATE_DT})

Thanks