Hi,
I've created a variable based on an If statement which returns 'Y' if a condition is met and 'N' if the condition is not met,
I'm now trying to qualify on that variable in an expression, but cannot get it to work
E.G.
count ( {$< LevelCode = {UG}, $(vname) = {'Y'} >} PersonID)
The expression performs the count regardless of whether the variable (vname) is Y or N.
I created the variable to get round another problem, where I am trying to only count the PersonID if 2 fields are equal to each other
E,G,
count ( {$ <LevelCode = {'UG'}, LengthStudy = YearStudy >} PersonID)
but that doesn't work either.
The variable is as follows:
=(if(LengthStudy = YearStudy, 'Y', 'N')
Help!!!!