In reports, you can add calculated fields and imported fields. This article explains the difference.
When adding a field to Omnia, you can either select a static value, an imported value, or a calculated value. Clicking on the formula bar shows a dropdown of all fields options.
Calculated fields
All fields with the database logo in front of it are calculated fields. This means that Omnia's Dynamic Pricing engine calculated the field (up to four times per day).
This table shows all calculated fields and how they are calculated:
| Field name | Calculation |
| Average Price Competitor(s) | Average price across the entire market |
| Marketing Bonus % |
Shows any marketing bonusses given by suppliers that are taken into account in Net Purchase Price (if configured under supplier conditions) |
| Minimum Price Competitor(s) | Minimum price out of all pricepoints that were found (incl. shipping costs) |
| # of UPV PDP last 4 weeks | Total number of unique page views on the product detail page (requires Google Analytics to be connected) |
| # Omni-Channel unit(s) sold last 4 weeks | Total number of units sold in the last 4 weeks (requires "Units sold total yesterday" to be mapped) |
| # Online unit(s) sold last 4 weeks | Total number of units sold online in the last 4 weeks (requires "Units sold online total yesterday" to be mapped) |
| # Store unit(s) sold last 4 weeks | Total number of units sold in stores in the last 4 weeks (requires "Units sold online total yesterday" to be mapped) |
| Payment condition % |
Shows any payment conditions given by suppliers for certain categories or brands that are taken into account in Net Purchase Price (if configured under supplier conditions) |
| Price Advice | The price resulted from your pricing strategy. To read more about the price advice, see this article. |
| Promo discount |
Shows promo discounts given by suppliers for certain SKUs that are taken into account in Net Purchase Price (if configured under supplier conditions) |
| Net Purchase Price | Adjusted purchase price, taking into account the supplier conditions: purchase price - promo discount - payment condition discount - marketing bonus |
Difference between the imported fields 'Units Sold yesterday' and 'Units Sold 7 days ago'
Units Sold yesterday: this field refers to the number of units sold yesterday
Units Sold 7 days ago: this field refers to the number of units on a specific day 7 days ago
E.g.: Today is the 28th of January
Units Sold yesterday: # of units sold on the 27th of January
Units Sold 7 days ago: # of units sold on the 21st of January