IF AND THEN ELSE

[Steve95]

Hi All

I have a number field which i have put a marker against....
The marker should populate 1 if then number isnull and also if it matches another number

What is happening is when i run the code below I am not getting the correct 1's populated....I could break down the formula to individual level and it works but I want one formula.....Just an interesting issue really....

Please can you help....

Syntax below


if isnull ({@Termination Counter}) and

{people.no} LIKE '*01*' OR
{people.no} LIKE '*02*' OR
{people.no} LIKE '*03*' OR
{people.no} LIKE '*04*' OR
{people.no} LIKE '*05*' OR
{people.no} LIKE '*06*' OR
{people.no} LIKE '*U/G*'
THEN 1 ELSE 0

 

[lupins46]

Try
EvaluateAfter({@Termination Counter})
as the first line of the formula.

 

[lbass]

What is the content of {@termination counter}? Also, please provide some samples of the {people.no} field.

-LB