I am trying to use the iff statement for the first time in a report variable.
I believe according to the syntax I should be able to combine using an “and” in
the condition statement
(IFF('.vmodel=.v1575 and .vserial > .vserial1575','3500','3300'))
But when I try to add it gives me the error:
NULLS cannot be used in comparisions other than NE or EQ.(2315)
Also, When I tried a single condition it does not like constants:
(IFF('.vserial>315046','3500','3300'))
but if I put the number in a variable and change it to:
(IFF('.vserial = .vserial315046','3500',.vgawr))
it works.
Am I doing something wrong?
TIA
Dan Goldberg
