Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • CDMS
  • Castor CDMS Calculations Manual
  • Introduction to calculations: the basics

Execute the calculation if not all variables have been filled in with in EDC/CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • CDMS
    Castor CDMS Manual Castor CDMS Calculations Manual Frequently Asked Questions Articles for Data Managers Castor CDMS Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents Castor Connect Manual Castor Connect - Participant Quick Start Guide
  • Helpdesk
    News Other Resources Castor products knowledge resources
  • Status page
  • Completing a Study
+ More

Table of Contents

The calculation

One of the messages that we might frequently see in our calculations is "Not all values for this calculation are available (yet)" (see Calculation errors). The message indicates that not all fields that are used in the calculation contain values. It can be inconvenient to see it on screen, especially in surveys. In this article we explain how you can hide this message, until all the relevant variables have been filled in.



It is important to note that:

  • this method is useful if the variables involved are mandatory
  • if zero (0) is an expected value in one of the fields, the arguments in the if-clause need to be modified
  • the calculation will work for all types of variables except for grid fields and checkboxes

The calculation

The rationale is to replace the empty fields with a zero (0). Then, use an if-else statement to check first if all our variables contain values that are different to 0. If they do, the desired calculation will execute (for example, the difference between two dates). While one of the dates has not been filled in (i.e. there are zeros), no message will be displayed in the calculation - field 3.3 in our example above.


In this example, the calculation would be as follows:

'##allowempty##';
'##setemptytozero##';
if('{DOB}' == 0 || '{CurrDate}' == 0){
"";
} else{
getDateDiff('{CurrDate}','{DOB}','y');
}


And this would be the outcome:




incomplete variables perform calculation

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Comparing variables with calculation fields in EDC/CDMS
  • Using the "if-else" logic in EDC/CDMS
  • Compare several numerical variables against a specific variable in EDC/CDMS
  • Forcing Castor to calculate with empty fields in EDC/CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media


Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand