Evaluating data when a field does not equal a value 1

[crachic]

I am trying to evaluate using a running total. Below is my formula that I have in my evaluate portion of the running total.

if {view_episode_summary_admit.preadmit_admission_date} >= (?Begin Yearly Admit Date}
then ({view_episode_summary_admit.program_code} <> '503' or
{view_episode_summary_admit.program_code} <> '101' or
{view_episode_summary_admit.program_code} <> '100')

My expected output is evaluating all episodes that do not equal 503, 101, or 100.

I know why problem is with the multiple codes I am trying to exclude on the evaluation because when I only exclude the first code (503) my totals are correct.

I am using Crystal Reports 11 if that helps at all.

Thanks in advance for your help.

-crachic

 

[lbass]

Set up the evaluation formula like this:

{view_episode_summary_admit.preadmit_admission_date} >= (?Begin Yearly Admit Date} and
not(
{view_episode_summary_admit.program_code} in ['503','101','100']
)

-LB

 

[crachic]

Thanks LB. I knew it was in my snytax. Great Post!

-crachic