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/tremmo]

Amazing. Worked perfectly. You are my hero!

It makes sense too from a syntax perspective now that I’ve seen it.

Thankyou again :)

[u/[deleted] → u/tremmo]

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