May 28, 2010 at 8:51 am
I have this condition in my conditional split:
(Code) == "" && (Consumption) >= "0" && (Rate) >= "0" && (TotalAmt) >= "0"
only rows that meet this condition shld be processed. otherwise, don't process.
Looks good to me, but didn't work when I tested it.
I'm thinking that it's because the "0" is in quotes, so it's being read as string. When I take the quotes out, the expression turns red - invalid.
Any ideas?
May 28, 2010 at 9:00 am
what are the data types of the columns?
May 28, 2010 at 9:05 am
they are all varchar.
that means that it should be in ""!
May 28, 2010 at 9:14 am
So the problem Should with the Code column.. Try using the below Exp
(!ISNULL(Code)) && ((Consumption) >= "0") && ((Rate) >= "0") && ((TotalAmt) >= "0")
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply