What Are Calculated Values?
A Calculated Value is a custom formula you build in Promo Intel to answer a business question, such as:
"Is my brand featured the most in the category?"
It allows you to manipulate numeric fields using logic and math, without referencing individual cells or generating text values.
✅ What Works
1. Use Numeric Fields Only
Calculated values can only be built using numeric fields. These typically appear in the Measures or Price/Numeric folders in Dynamic Summary.
Examples include:
Ad PriceUnit PriceTotal Savings Amount ($)Net Unit PriceAdBlocks(when used with Distinct Count)AdsProducts
⚠️ Fields like # in Pack may appear numeric (e.g., “4ct/pk”) but are stored as text and cannot be used in formulas.
2. Supported Operators and Functions
Arithmetic Operators
+,-,*,/,^
Logical Operators
>,<,>=,<=,!=
Functions
if()and(),or()abs()rd()min(),max()
🚫 What Doesn’t Work
Text Comparisons or Outputs
You cannot generate or compare text. Use binary flags (
1or0) instead.❌
if(SalePrice > 3, "High", "Low")
✅if(SalePrice > 3, 1, 0)
No Cell References
You cannot reference grid cells like
A1,B3. Use field names likeAverage Ad Price.
No Cross-Row/Column Logic
Formulas only evaluate within a single row-column intersection.
You cannot compare 2024 vs 2025 within a formula. Use a variance field instead.
Summary Table
✅ Supported | 🚫 Not Supported |
Numeric fields | Text fields or pseudo-numeric values |
Arithmetic & logical operators | Text comparisons or outputs |
Field-level logic only | Row-to-row or column-to-column calculations |
Binary values ( | Labeling or classification using text |
Function-based expressions | Cell references (e.g., |
Suggested Articles:
Last updated: 6/2/2025