Joined: 09 Jan 2014
Location: United States
Online Status: Offline
Posts: 5
Topic: IF-THEN statement - Not returning values Posted: 28 Jul 2014 at 4:38am
I have a pretty simple IF-THEN statement:
if {@Translate} <> "Down Unit" and {LRCON.Status} = 312 then {LRCON.CusName} else
if {@Translate} = "Down Unit" then "Down Unit" else
if isnull({@Translate}) then "Available" else
"Available"
I have about 150 records, and it works perfect on all except 2. The output it just "null". In both cases, the records return nothing at all. They should at least be putting out "Available", correct? Why aren't they??? :(
Joined: 09 Jan 2014
Location: United States
Online Status: Offline
Posts: 5
Posted: 28 Jul 2014 at 5:11am
Yea, I threw that null in there to try to catch any errors... but I figured it out. {LRCON.CusName} didn't exist for some records, so I added another string to it. Thanks for the quick response!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum