IF/ELSE: Define conditional variables (if / else logic)

Step 1: Create the variable

• Click “+ New variable”
• Enter a name (e.g., Age over 18)
• Choose the appropriate type (Yes/No, Numeric, List, or Event)
  The return values of your formula must match this type

Step 2: Add a formula

• In “Dynamic variable”, click “Add formula”

Step 3: Use the If helper

• In the left panel, click “If”
• A template is automatically inserted:

 

  

   

    

     

      

       

        

        

         

          

           

            

             

              if (condition) { value_if_true } else { value_if_false }
             
            
           
          
         
        
       
      
     
    
    

     

    
   
  
 

Step 4: Define the condition

• Replace condition with your logic
  Example with a numeric variable:

 

  

   

    

     

      

       

        

        

         

          

           

            

             

              Age_at_inclusion > 18
             
            
           
          
         
        
       
      
     
    
    

     

    
   
  
 

• You can use standard operators: >, <, >=, <=, ==, !=
• Conditions can be combined or nested if needed

Step 5: Define the return values

The values you return must match the variable type:

• Yes/No variable
  Return YES or NO (written in full text)

 

  

   

    

     

      

       

        

        

         

          

           

            

             

              if (Age_at_inclusion > 18) { YES } else { NO }
             
            
           
          
         
        
       
      
     
    
    

     

    
   
  
 

• Numeric variable
  Return a number or another numeric variable

 

  

   

    

     

      

       

        

        

         

          

           

            

             

              if (Age_at_inclusion > 18) { 1 } else { 0 }
             
            
           
          
         
        
       
      
     
    
    

     

    
   
  
 

• List variable
  Select a modality using the autocomplete dropdown
• Event variable
  Return either:
  • another event variable
  • or a specific date

Step 6: Use nested conditions (optional)

You can create more complex logic by nesting conditions:

 

  

   

    

     

      

       

        

        

         

          

           

            

             

              if (Age_at_inclusion > 65) { YES } else { if (Age_at_inclusion > 18) { YES } else { NO } }
             
            
           
          
         
        
       
      
     
    
    

     

    
   
  
 

Step 7: Validate your formula

• Use the Patient Values panel on the right
• It allows you to test the formula on existing patients
• This helps verify that your logic behaves as expected

Step 8: Confirm

• Check the “Variable mapping” if needed
• Click “Confirm” to save the formula