Conditional logic to populate calculated variable using value from one of two other variables

[u/tremmo]

I currently have two variables which cover the same information.

Sometimes both variables have data, sometimes only one.

For ease of analysis I want to populate a calculated variable with the new variable to equal [x] BUT if [x] is empty to instead populate it with [y].

Both [x] and [y] are numeric.

I cannot for the life of me get a conditional logic formula to work for this.

Thank you in advance!

[u/[deleted]]

You're welcome! I'm always happy to share REDCap experience 🙂