How to change a formula response of Y to "Yes"?

[Former Member]

My 1st formula is   

if {FOCUS_VIEW.PT_AGREE_TO_PARTICIPATE} = 'Y' then 1

I would like it to show up in the report as Yes instead of 1

The 2nd formula is

if not isnull ({FOCUS_VIEW.CALL_1_DATE_OF_CALL}) then 1

I would like it to show up in the report as Yes instead of 1

[abhilash_kumar · Accepted solution]

Hi Michael,

Change the code to:

if {FOCUS_VIEW.PT_AGREE_TO_PARTICIPATE} = 'Y' then 'Yes'

and the other one to:

if not isnull ({FOCUS_VIEW.CALL_1_DATE_OF_CALL}) then "Yes"

-Abhilash

[Former Member · Accepted solution]

Abhilash,

I already tried that and got the error message below.

[abhilash_kumar · Accepted solution]

You missed the quotes!

-Abhilash

[Former Member · Accepted solution]

Oops...I fixed it and it works

Thanks