#### Welcome!

We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

# If Then Statements in calculated fields

Posts: 5
SPartners
In CRF design (excel worksheet) what is the syntax to create an If/Then statement (assuming these type of calculations are accepted in the CRF design).

For example:
(IF field1 is NULL THEN field2 = "0" ELSE field2 = "1")

Thanks,

Jeremy Gooch

• Posts: 0
SPartners
Hello Jeremy,

You can have a lookup and return value with having a calculated field using decode. Using the ITEM_NAME as the variable and RESPONSE_VALUES for lookup value; e.g.:

func: decode(field1,NULL,0,1)

Best Regards,

Alicia

. . . . . . . . . . . . . . . . . . . .

Alicia Goodwin
Akaza Research
400 One Kendall Square
Cambridge, MA 02139
tel: 617.621.8585 ext. 24
[email protected]
www.akazaresearch.com

www.openclinica.org
Open Source Platform for Clinical Research
Sent: Wednesday, May 27, 2009 5:57 PM
To: [email protected]
Subject: [Users] If Then Statements in calculated fields

In CRF design (excel worksheet) what is the syntax to create an If/Then statement (assuming these type of calculations are accepted in the CRF design).

For example:
(IF field1 is NULL THEN field2 = "0" ELSE field2 = "1")

Thanks,

Jeremy Gooch
• Posts: 5
SPartners
Thanks Alicia,

That seemed to get it!

Jeremy Gooch
Sent: Thursday, May 28, 2009 10:05 AM
To: [email protected]
Subject: RE: [Users] If Then Statements in calculated fields
Hello Jeremy,

You can have a lookup and return value with having a calculated field using decode. Using the ITEM_NAME as the variable and RESPONSE_VALUES for lookup value; e.g.:

func: decode(field1,NULL,0,1)

Best Regards,

Alicia

. . . . . . . . . . . . . . . . . . . .

Alicia Goodwin
Akaza Research
400 One Kendall Square
Cambridge, MA 02139
tel: 617.621.8585 ext. 24
[email protected]
www.akazaresearch.com

www.openclinica.org
Open Source Platform for Clinical Research
Sent: Wednesday, May 27, 2009 5:57 PM
To: [email protected]
Subject: [Users] If Then Statements in calculated fields

In CRF design (excel worksheet) what is the syntax to create an If/Then statement (assuming these type of calculations are accepted in the CRF design).

For example:
(IF field1 is NULL THEN field2 = "0" ELSE field2 = "1")

Thanks,

Jeremy Gooch
This discussion has been closed.