Hello: The following formula is

[morechocolate]

Hello:

The following formula is not returning the correct data. If a there is a rating of Aaa it should return as Y, not N. I would appreciate it if someone could tell me why this is?

IF {vExtHoldingReports.RATING} IN ["AAA","AA"] then
"N" else "Y"

Thanks

Pam

 

[goranm]

Hi !

Have you checked the "Case-Insensitive SQL Data" ?
You find it under File | Report Options

/Goran

 

[rhinok]

If you are using Oracle then you should know that Oracle doesn't support case insensitivity.

 

[mbarron]

Using the UCase funtion will give you the desired result
It will read the string as all uppercase letters.

IF UCase({vExtHoldingReports.RATING}) IN ["AAA","AA"] then
"N" else "Y" Mike

 

[morechocolate]

Thank You everyone for such prompt responses.

BTW, rhionk, we are not using Oracle.

Pam

 

[mbarron]

I just re-read your post.

Read it as if you had "then "Y" else "N"

My formula would cause the same result you are already getting.



Mike