| Anchor | ||||
|---|---|---|---|---|
|
...
- To insert a Case statement, click the CASE button in the Formula Builder.
- Click on the WHEN button will open a popup and create your first WHEN condition and THEN instruction.
Note: it operates similar to the formula builder, only allowing formula objects to be inserted where they are valid.
- Click OK to complete your condition/instruction
- Continue adding WHEN conditions until you have covered all the possibilities required
- Add an ELSE condition if needed, this is optional, but recommended.
- Add your END component
- Save & Activate your calculation
...