> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://label-wizard.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Formulas and advanced fields

### When to use a formula

Use a formula when a single field is not enough, for example:

- Combining title and option values into one line
- Formatting a price or other number
- Pulling a value through a product reference
- Showing a value from a related group of variants

Start with simple field insertion first. See [Showing product data on labels](/en/article/dynamic-product-data-1efsqbg/). Switch to **Formula** mode in the token editor when you need more control.

![Token / formula editor open on a text field](https://leftfootsoftware.github.io/Help-Label-Wizard/v1/assets/en/FormulasAndExpressionsEditor.png)

### Editing a formula

1. Select the object that should show the value.
2. Open the field editor and switch to **Formula** when available.
3. Build the expression with the helpers and fields offered in the UI.
4. Apply the change and preview with a real variant.

### Errors vs empty data

Label Wizard treats these differently:

- **Empty data** — the product simply has no value; the label may show a blank. That can be correct.
- **Broken formula** — the expression itself is invalid. The editor should show an error you can fix. Do not ignore formula errors and assume the print will look fine.

If something looks wrong, fix the formula or the product data, then preview again before printing.

### Related product and group data

Advanced designs can reference related products or values across variants (for example matching variants in a group). Keep these expressions as simple as you can, and always preview several products.

### Related articles

- [Showing product data on labels](/en/article/dynamic-product-data-1efsqbg/)
- [Flex regions](/en/article/flex-regions-1iqpgwv/)
- [Troubleshooting common printing problems](/en/article/troubleshooting-printing-1cy4nth/)