Simple Case Function

[Joseph31]

Hello Everyone,

I have two fields

"Text Field"

"Yes / No "

Case ( Text Field = ""; "No"; "Yes")

In excel this "" means blank... So I thought that it might mean that here in FM also. Half of the equation works... when there is something in the text field the yes no statement goes to yes but when there is nothing the yes no fuction does not do anyting but go blank... I woul like it to say NO if possiable.

Joseph

[RalphL]

Use the IsEmpty function. Case ( IsEmpty ( Text Feild); "No"; "Yes")

[Joseph31]

Ok cool that works....

Thank you.

Joseph