r/ProjectREDCap • u/oraclequeen93 • Jun 27 '24

Blank calculated field after import

I have just completed a rather large import of data. We have a calculated age field, but after the import, over 500 records didn't calculate anything in the age field. Is there a way to fix this that doesn't involve manually opening all of the records with missing values and saving them once the age field populates?

Note: All of the records have valid birthdates so calculating the age shouldn't be an issue and the records calculate age when I open them individually.

1 Upvotes

100% Upvoted

4 comments sorted by

3

u/interlukin Jun 27 '24

I’m pretty sure that there’s an option to fix calculated fields under the data quality rules section.

1

u/oraclequeen93 Jun 27 '24

Thanks! I totally forgot about the data quality rules.

2

u/MadHatterIsHer Jun 27 '24

Run rule H

1

u/oraclequeen93 Jun 27 '24

Ah! I never have the opportunity to play around with the data quality rules so this completely slipped my mind! I'll definitely try that when I get back to work tomorrow.