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
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