Not Like Formula 1

[IceRuby]

Hi

I am trying to apply a not like formula within an if statement but crystal keeps advising error.

Formula is

if {Posting Date} in [{@PeriodStartDate} to {@LastTuesdayInMth}] and {Sale Type} = [2] and not{description} like('Marginal*') then {Quantity} else 0

Crystal error states boolean required and highlights field after not(description).

thanks for your help in advance.

 

[rosemaryl]

Dear IceRuby,

I think that should be:

if {Posting Date}
in {@PeriodStartDate} to {@LastTuesdayInMth}
and
{Sale Type} = 2
and
not({description} like('Marginal*'))
then {Quantity}
else 0

You must enlocse the statement that not is evaluating in parentheses. Also, I am not sure why you used [ brackets in your formula.

The above, when replaced with fields that I have passes the formula syntax checker.

Regards,

ro


Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.