Column dictionary

ConsumedQuantity

Consumed Quantity · Cost and Usage dataset

Feature level
Conditional
Data type
Decimal
Allows nulls
Yes
Column type
Metric

What it is

The Consumed Quantity represents the volume of a metered SKU associated with a resource or service used, based on the Consumed Unit. Consumed Quantity is often derived at a finer granularity or over a different time interval when compared to the Pricing Quantity (complementary to Pricing Unit) and focuses on resource and service consumption, not pricing and cost.

Requirements (8)

Verbatim from the specification. These are the statements the validator checks against.

  • ConsumedQuantity MUST be of type Decimal.
  • ConsumedQuantity MUST conform to NumericFormat requirements.
  • ConsumedQuantity MUST adhere to the following nullability requirements:
  • ConsumedQuantity MUST be null when SkuPriceId is null.
  • ConsumedQuantity MUST be null when ChargeCategory is not "Usage", or when ChargeCategory is "Usage" and CommitmentDiscountStatus is "Unused".
  • When ChargeCategory is "Usage" and CommitmentDiscountStatus is not "Unused", ConsumedQuantity MUST adhere to the following requirements:
  • ConsumedQuantity MUST NOT be null when ChargeClass is not "Correction".
  • ConsumedQuantity MAY be null when ChargeClass is "Correction".

Check your own export

The FOCUS 1.4 validator checks this column and 122 others against your file, in your browser, with no size cap and nothing uploaded.

Other Cost and Usage columns

Definition taken from the FOCUS 1.4 specification. FOCUS is published by the FinOps Foundation under CC BY 4.0.

One column is a definition. A pipeline is a project.

Finitizer ingests FOCUS from every provider you run and reports across all of them.