Conditions

Conditions are expressions you define to control calculations.

These are the key concepts to understand when working with conditions in Decipad:

• Booleans : Booleans represent pairs of data with values of true or false. They are used to define conditions and make decisions in your code. Booleans can also be the result of a comparison or logical operations.

• Comparison Operators: Comparison operators allow you to compare values and return a boolean value (true or false) based on the result of the comparison. Common comparison operators include:

  • Greater than >
  • Less than <
  • Greater or equal than >=
  • Less or equal than <=
  • Equal to ==
  • Different to !=

  Example: For a Price = $200 the condition Price > $100 is true, however, if Price is $300 the condition is false.

• Logical Operators: Logical operators enable you to combine and manipulate boolean values. The not operator negates a boolean value, and returns true if both operands are true, and or returns true if at least one operand is true.

  Example: TotalSales < $500 and Discount > 5%.

Combining comparison and logical operators allows you to create conditions that evaluate to either true or false. They can be used to control your calculations based on their outcome,

Here's a simplified version:

---

If-Then-Else Conditions

The if-then-else statement allows you to create conditional calculations. It evaluates a condition, then returns one of two specified results based on whether the condition is true or false. It's crucial that both results have the same data type or unit to prevent errors.

Syntax

if [Condition] then [Result if True] else [Result if False]

Examples

In this example, if the condition Item > $200 is true, "Overpriced" is returned; otherwise, "Underpriced" is returned.

if Item > $200 then "Overpriced" else "Underpriced"

Additionally, you can use the keyword first in tables to check if it's the first row:

if first then "I am the first row" else "I am not the first row"

You can also compute income increases based on a slider value:

if first then IncomeSlider else previous(0) + 5%

Verification Conditions

Syntax

assert([Condition])

To ensure that certain conditions are met on your notebook, you can use the assert() statement. It checks a condition and creates an error in the notebook if the condition is not true. This helps in validating assumptions and catching errors.

Examples

assert(Sales >= $0)

If Sales < $0 an error will be generated, highlighting any discrepancy on your notebook.

Checking Multiple Conditions

Syntax

[Result] = match {
  [Condition 1]: [Result 1]
  [Condition 2]: [Result 2]
  [Condition 3]: [Result 3]
              ...
}

The match{} statement tests a group of conditions and returns a value when a true statement is found. It simplifies decision-making based on specific conditions.

Examples

Suppose we have a variable Performance with the value "Exceeds". We want to determine the bonus based on the performance level.

In this example, the Bonus variable will be assigned the value of 2% because the value of Performance matches the condition "Exceeds". The match() statement allows us to specify different conditions and their corresponding results or calculations.

Calculating Tiers

Syntax

tiers [Your Value] {
         [Tier 1]: [Value or Calculation]
         [Tier 2]: [Value or Calculation]
         [Tier 3]: [Value or Calculation]
                            ...
  [Optional] rest: [Value or Calculation]
  [Optional]  max: [Value or Calculation]
  [Optional]  min: [Value or Calculation]
}

Tiers allow you to slice a number into different levels and perform calculations on each tier. It simplifies complex scenarios such as tiered sales commission structures or progressive tax systems.

Examples

Let's consider a sales commission scenario where the commission rate varies based on the sales amount (YourSales).

In this example, the YourSales variable is divided into different tiers based on the specified thresholds. The commission percentage changes as the sales amount crosses these thresholds. The tiers statement allows us to define calculations for each tier and handle scenarios beyond the defined thresholds.

Reusing Tiers with a Custom Function

To make tier calculations more reusable, you can define a custom formula that incorporates the tiers.

Examples

In this example, the CalculateSales formula takes the YourSales variable as input and applies the tiered calculation defined in the tiers formula. This allows you to easily calculate sales based on different sales amounts by using the CalculateSales() formula.

By calling CalculateSales($120000), you will get the result based on the tiered calculations for that specific sales amount.