Calculated attributes
A calculated attribute is an attribute like any other attribute but its literal value is a formula that is used to calculate a result based on other attribute values.
If it helps, think Microsoft Excel. Excel also uses the concept of formulas, but it operate on cells instead of attributes, and worksheets or books instead of products (or other entities).
Click to expand Excel analogy...
Here we have a cell A:1 with the value "My name", and another cell A:2 with a formula "=LEN(A1)" and the result 7 which is the length of the string value in A:1.
But what is the use of it in PIM?
It allows users to create dynamic attributes. For example:
- Metadata: concatenate various string attributes like NAME, SERIES, etc. into a single field that can be used as meta title, meta description, etc. in a webshop
- Price incl. VAT: add VAT on top of PRICE
- Enrichment quality: make a simple enrichment quality assessment based on the length of various fields like for example DESCRIPTION
Functions
| Function |
|---|
| CONCAT |
| ISNULL |
| ISBLANK |
| TEXT |
| NUMBER |
| OR |
| AND |
| XOR |
| NOT |
| BLANKASFALSE |
| LEN |
Operators
| Operator |
|---|
| ( |
| ) |
| * |
| / |
| % |
| + |
| - |
| > |
| < |
| <= |
| >= |
| == |