nios
Collect data

Issues

Everything that stops or weakens a result, from import to calculation.

An activity is calculated only when the values it needs are usable, it has a base sector, and Nios finds a factor for each environmental pressure (metric), such as GHG emissions. The Issues tab in the side panel lists what stands in the way, on every Collect page. This page explains the issues in the order they come up, and lists every issue Nios raises.

How issues work

Every issue is an error or a warning:

  • Error: A value Nios can't use, such as an unknown currency or a missing base sector. Nios doesn't calculate the activity until you fix it. An error in a metric column stops only that metric. Activities without errors are calculated as usual.
  • Warning: Something worth checking that doesn't stop the calculation, such as a regional factor used instead of a country factor. You can mark a warning as reviewed. It comes back if the finding changes.

Issues show as tinted cells in the grids, as counts next to the Collect pages in the sidebar, in the status bar above each grid, and in the Issues tab.

Status bar

When a Collect page has errors, its status bar turns red and shows how many there are. Step through the error cells with the arrows on its right. The counter shows where you are, for example 2/5. If the next error is in a row your current view hides, Nios shows the row anyway, and Back to filtered view returns you to your view.

Red status bar showing the message Production country not recognized, the counter 1/2, and arrows to step through errors

Select a cell with an issue to read its message in the status bar. Click the message, or the warning count, to open the Issues tab.

Issues tab

Open the Issues tab with Open panel in the top right, or from the status bar.

Issues tab with the error group Production country not recognized, replacing Finnland with Finland, and the Fix button

The Issues tab groups issues by message and value, errors first. Issues from matching and calculation follow under Matching. Reviewed warnings move to Reviewed, and Other modules links to issues on the other Collect pages. Show jumps to the affected cells in the grid.

One fix can solve a whole group:

  • Replace with or Fill with: Pick one value, then click Fix to apply it to every row in the group. Nios preselects a close match, for example Finland for "Finnland".
  • Add as entity: Creates the organization entity an activity names, so the reference works.
  • Mark as reviewed: Accepts a warning.

Data issues

Nios checks every row when you import it and again on every edit, on all three Collect pages. Fix these first, because they decide what Nios can match and calculate. For the columns each stage needs, see What Nios needs.

Most data issues are values that are missing, paired without their partner, not a number, negative, or not in the list. An impact input with errors stops its metric on every activity that uses it. An organization entity with errors shows an error on the activities that name it, but they're still calculated. See the data issues reference.

Matching issues

After sector matching, some activities can still be without a base sector:

  • No base sector match found: Sector matching found no sector that fits well enough. Make the Activity more specific or add the Supplier. Both edits retry matching. Or select a base sector yourself.
  • Sector matching failed: The matching run failed for this activity. Click Match to retry, or select a base sector yourself.

Matching > Review lists these activities together with the matches worth checking. See Review and improve matches.

Calculation issues

With a base sector or impact input in place, Nios calculates each metric. A calculation issue means a value the calculation needs is missing, or there's no factor for the sector and country. An impact input that doesn't fit the activity, such as a unit mismatch, shows as a data issue on its metric cell instead. Depending on the issue, Nios can't calculate the whole activity or one metric.

Warnings at this stage mark results you should check, for example when Nios used a regional factor because the country has none, or when an activity has no spend and stays out of intensities. See the calculation issues reference.

Issue reference

The messages below are the exact text in the app. Values in braces, such as {metric}, are filled in for the row.

Data issues: Activities

MessageColumnSeverityWhat to do
Missing activityActivityErrorType the activity name
Duplicate activity nameActivityErrorRename the duplicates so each activity is unique
Needs spend+currency or quantity+unitSpend, Currency, Quantity, UnitErrorAdd a spend with currency, or a quantity with unit
Spend without currencyCurrencyErrorSelect the currency
Currency without spendSpendErrorAdd the spend amount
Quantity without unitUnitErrorSelect the unit
Unit without quantityQuantityErrorAdd the quantity
Spend is not a numberSpendErrorEnter the spend as a number
Quantity is not a numberQuantityErrorEnter the quantity as a number
Negative spendSpendErrorEnter a spend of zero or more
Negative quantityQuantityErrorEnter a quantity of zero or more
Year out of rangeActivity yearErrorSelect a year from 2018 to 2026
Currency not supportedCurrencyErrorSelect an ISO currency code from the list
Unit not recognizedUnitErrorSelect a unit from the list
Production country not recognizedCountry of productionErrorSelect a country from the list
Purchase country not recognizedCountry of purchaseErrorSelect a country from the list
Country used not in listCountry usedErrorSelect Production or Purchase
Not a supported base sectorBase sectorErrorSelect a sector from the catalog, or click Match
Entity not in Organization entitiesEntity nameErrorFix the name, or choose Add as entity
Entity has errors in Organization entitiesEntity nameErrorFix the entity's errors on Organization
Impact input not foundMetric columnErrorSelect an existing impact input, or fix its name
Impact input has errorsMetric columnErrorFix the impact input's errors on Impact inputs
Wrong metric: this impact input is for {metric}Metric columnErrorSelect an impact input for this column's metric
Result already used on another rowMetric columnErrorA Tier A result applies to one activity only. Create a separate result for this row
Needs quantity and unit · {metric}Metric columnErrorAdd quantity and unit, or select a different impact input
Unit mismatch: factor per {denominator}, row in {unit}Metric columnErrorAlign the activity's unit with the factor's denominator
Needs spend and currency · {metric}Metric columnErrorAdd spend and currency, or select a different impact input
Sector not foundMetric columnErrorSelect a sector from the current catalog
Sector country not recognizedMetric columnErrorSelect a country from the list
Price per unit is not a numberPrice per unitWarningEnter the price as a number
Negative price per unitPrice per unitWarningEnter a price of zero or more
Type not in listTypeWarningSelect Physical goods, Services, or Digital
Scope category not in listScope categoryWarningSelect 3.1 Purchased Goods & Services
Price type not in listPrice typeWarningSelect Basic, Purchaser, or Unknown

Data issues: Organization

MessageColumnSeverityWhat to do
Missing entity nameNameErrorName each entity
Duplicate entity nameNameErrorRename the duplicates so each entity is unique
Consolidation approach not in listConsolidation approachErrorSelect Operational control, Financial control, or Equity share, or leave it empty
Differs from the consolidation approach used aboveConsolidation approachErrorUse one consolidation approach for all entities
Consolidation % is not a numberConsolidation %ErrorEnter the ownership share as a number
Negative consolidation %Consolidation %ErrorEnter an ownership share between 0 and 100
Consolidation % out of rangeConsolidation %ErrorEnter an ownership share between 0 and 100
Control approach needs 0 or 100 ownershipConsolidation approach, Consolidation %ErrorWith Operational or Financial control, enter 0 or 100
Include in boundary must be Yes or NoInclude in boundaryErrorSelect Yes or No
Type not recognizedTypeWarningSelect an entity type from the list
Country not recognizedCountryWarningSelect a country from the list
Revenue is not a numberRevenueWarningEnter the revenue as a number
Negative revenueRevenueWarningEnter a revenue of zero or more
Revenue currency not supportedRevenue currencyWarningSelect an ISO currency code from the list
Employees is not a numberEmployeesWarningEnter the employee count as a number
Negative employeesEmployeesWarningEnter an employee count of zero or more
Not defined in Organization entitiesHierarchy levelWarningAdd the entity on Entities, or fix the name
Duplicate entity in hierarchyHierarchy levelWarningPlace each entity at one position in the hierarchy
Entity not in hierarchyNameWarningPlace the entity in the hierarchy

An error on an entity also blocks the activities assigned to it. They show "Entity has errors in Organization entities" until you fix the entity.

Data issues: Impact inputs

MessageColumnSeverityWhat to do
Missing input nameInput nameErrorName each impact input
Duplicate input nameInput nameErrorRename the duplicates so each impact input is unique
Missing metricMetricErrorSelect the metric
Metric not in listMetricErrorSelect a metric from the list
Missing tierTierErrorSelect A, B, or C
Tier not in listTierErrorSelect A, B, or C
Missing valueValueErrorEnter the value
Value is not a numberValueErrorEnter the value as a number
Negative valueValueErrorEnter a value of zero or more
Denominator does not fit tierDenominatorErrorTier A: leave empty. Tier B: a quantity unit. Tier C: EUR or USD
Denominator not in listDenominatorErrorSelect a denominator from the list
Missing LCA activityLCA activityErrorSelect Cradle-to-gate
LCA activity not in listLCA activityErrorSelect Cradle-to-gate
Year out of rangeReference yearErrorSelect a year from 2018 to 2026
Input name uses reserved sector syntaxInput nameWarningRename the input so it can't be mistaken for a sector name
Reference region not in listReference regionWarningSelect a region, or Other and note the location in Comment

Matching issues reference

MessageSeverityWhat it meansWhat to do
No base sector match foundErrorSector matching found no sector that fits well enoughClarify the purchase in Activity and check Supplier. These edits retry matching. Or select a base sector
Sector matching failedErrorThe matching run failed for this activityClick Match to retry, or select a base sector

Calculation issues reference

MessageSeverityApplies toWhat it meansWhat to do
Missing spendErrorActivityThe calculation path needs spendEnter Spend and Currency, or select a quantity-based impact input
Missing activity yearErrorActivityNios needs a year to adjust spend to the factor's yearSelect an Activity year
Missing production countryErrorActivityNios adjusts spend with the production country's inflation seriesSelect a Country of production
No deflator data for countryErrorActivityThe production country has no inflation seriesSelect the closest country with data, or use an impact input per metric
No exchange rate for currencyErrorActivityNo exchange rate covers this currency in the factor's yearSelect another Currency, or use an impact input per metric
No metric sector foundErrorMetricThe base sector doesn't resolve to a sector for this metricSelect a sector or impact input in the metric cell, or change the base sector
No factor foundErrorMetricNo factor covers this sector and country, even after the regional and global fallbacksSelect another sector or impact input in the metric cell, or change the base sector or country
Review price typeWarningMetricThe price type isn't Basic. Spend with taxes and margins can overstate resultsUse spend without taxes and margins where you can, and set Price type to Basic
No factor reference yearWarningMetricThe factor has no reference year, so Nios uses the spend without adjusting itCheck the factor's year and the result
Regional factor usedWarningMetricThe sector has no factor for this country, so Nios uses the regional oneReview, or select a country or impact input
Continental factor usedWarningMetricThe sector has no factor for this country, so Nios uses the continental oneReview, or select a country or impact input
Global factor usedWarningMetricThe sector has no factor for this country, so Nios uses the global oneReview, or select a country or impact input
Not counted in intensitiesWarningActivityThe activity has no spend Nios can convert to the base currency, so it's left out of every intensityEnter spend and currency, or check that exchange rates cover the activity year