How to make calculation formula 2

[coolbrz]

I have imported data from another program (private advantage) one field will need to post Male or Female. What I am getting is True for Male and False for Female. How do I get True to post Male and False to post Female?

Thanks from a newbe

 

[CryoGen]

I'm not sure if this is what you're getting at, but try this:

Case(

yourfield = "Male", "True",
yourfield = "Female", "False"

)

 

[coolbrz]

Hi,

The Case function should work here but I am not getting any output. I think there is another item I have not put into my formula to allow the the field to show the desired content.

additional suggestions?

Thanks,

 

[CryoGen]

You might have a syntax error there. Can you copy and paste the code in that calculation here?

 

[TStriker]

Cryogen's example may be backwards. Try this:

Case ( yourfield = "True"; "Male"; "Female" )

In plain english this says; if the existing value is "True" then change it to "Male" otherwise change it to "Female".

-Striker

 

[TStriker]

Coolbrz,

Oops, this might be safer:

Case (
yourfield = "True"; "Male";
yourfield = "False"; "Female";
"unknown"
)

In my previously posted formula it didn't take into account the fact that the gender may be unknown.

-Striker