CODEWITHSUNDEEP
crystal-reports
Yohan Greenburg
Yohan Greenburg

Reputation: 333

Unable to deciper formula field syntax

I'm trying to decipher a Crystal Reports formula field, but I'm not sure what this syntax is saying. I understand what the ISNULL() is for, but does the >"." mean?

if isnull({r.userid}) or not ({r.userid}>".") then {r.empID} else {r.userid}}

What is the or not ({r.userid}>".") statement saying? I don't follow the logic in that.

Upvotes: 0

Views: 35

Answers (1)

CoSpringsGuy
CoSpringsGuy

Reputation: 1645

That's an interesting way to do this but it is basically saying if userid is null or if the asci value of the first character of userid is NOT greater than 46. This will return The username if it is not null or starts with anything other than special characters.

Upvotes: 1

Related Questions