Comment on page
If statements
When you want a variable to have different values or formulas based on a condition, you can use if-statements. They always have to follow the structure
if condition then X else YYou can link multiple conditions with
and and/or or:if condition1 or condition2 then value1 else value2if condition1 and condition2 then value1 else value2
You can also link conditions with a list using the syntax
IN, for example:if month in [11, 12, 1, 2] then 90% else 100%-> means if the month is Nov, Dec, Jan or Feb, return 90% else return 100%.- You can also use categories / category items in if-statements, see Category Items in formulas for more.
You can have multiple layers of if statements too, for example:
if condition1 then value 1 else if condition2 then value2 else [...]- You can break each of these layers out onto separate lines of your formula editor using shift + enter
- Note that every if statement must have an else, otherwise Causal will return an error.
Examples of if statements:
if timestep > 4 then 1 else 0if variable1 > variable2 then 100 else 200if timestep > 4 and timestep < 10 then 1 else 0if variable1 < 10 then 100 else if variable1 < 20 then 200 else 300
Last modified 4d ago