Start a conversation

General calculation templates

  • Calculating with checkbox fields

    * Note: when testing your calculation with checkboxes in the Calculation Helper, use commas (,) as separator instead of semicolon (;). On the contrary, Castor EDC uses semicolon (;). Check if a box wa...

  • Calculate with grid fields

    You can also calculate with grid field values. For example, you can calculate the sum of a row or column in your grid. This of course makes sense if you are using numerical fields, but can sometimes a...

  • Check if a number contains X number of digits or decimal places

    Using calculation fields, it is possible to check if the number that is entered in a numerical field corresponds to a certain format. For example, you can check if a number contains 3 digits or if it ...

  • Validation or dependency on an empty field

    See here how you can allow empty fields in a calculation. If you want to create a validation warning or a dependency when there is no data entered in a field, you can use a calculation field to check ...

  • Calculate the score from several variables

    You can add values from different fields together using a calculation field. For example, you can use this template to calculate a risk score based on multiple risk factors. In this example we use the...

  • Converting weight and length units

    Sometimes you need to convert the units of a given measure to keep a unified format across your study. These conversions are usually inches or feet to centimetres and pounds to kilograms, or vice-vers...

  • Check if a report was added

    Check with calculation To check if a report (e.g. an SAE form) was added, you can check if a required variable name on the report has been defined. You need the following syntax to achieve this: '##al...

  • Check if a text field contains any numbers

    When using a text field, you can use the following template to check whether the field contains any numbers and display a message of your choice.  Create a calculation field in the study form using th...

  • Check if all fields are filled in

    If you want to check whether certain fields are filled in, you can use the template below. In this template, there are 2 fields:  Variable name Field label dem_pat_gender Gender dem_pat_yob Year of Bi...

  • Check if the inclusion criteria are met

    Using calculation fields, it is possible to check if a patient fulfills certain inclusion criteria. Below is an example that checks whether a patient has a certain disease (variable {pat_has_example})...