Revenue Values and the Display Unit of Measure

Revenue Values and the Display Unit of Measure

A calculated demand type with Units set to Revenue keeps the same value when you change the display unit of measure (UOM) in Collaboration. Its formula reads each operand in the item's base UOM, not the UOM selected for display. Only a currency change moves a Revenue value.

For example, a demand type calculates [NSP] * [SBU Forecast]. The item's base UOM is Each, NSP is $3.00 per Each and the forecast is 120 Each:


The forecast row changes with the display UOM, as it always has. The Revenue row stays at $360, because the formula still reads 120 Each × $3.00.

Turn it on

The behavior follows the Units setting of the demand type. There is no separate setting or feature flag, and it can't be turned off for a Revenue demand type.
  1. Go to Settings > Demand > Demand Types.
  2. Click Edit on the calculated demand type, or click + Add New.
  3. Set Type to Calculated Quantity and Units to Revenue.
  4. Click Save.

A demand type left at Units = Quantity still changes with the display UOM, even if its name or formula describes money. Check the Units setting on any existing price-times-quantity demand types.

What it covers

For a Revenue demand type, these operands are read in base UOM:



If the Revenue demand type itself has no UOM set, its Price and Quantity operands are still read in base units and produce a calculated value.

What doesn't change

  1. Quantity demand types still convert with the display UOM.
  2. Invariant demand types still pass through unchanged, as before.
  3. The Price demand type's own row, such as NSP, behaves as it did before. Only formulas that reference it in a Revenue demand type are affected.
  4. The Quantity demand type keeps converting with its UOM everywhere else it's used.

Known limitations

These elements are still read in the display UOM inside a Revenue formula. This is expected behavior, not a defect:
  1. A nested calculated demand type used as an operand
  2. Extension operands
  3. SFIE operands
  4. A weighted-revenue formula that has no currency set
If a Revenue value still changes with the display UOM, check whether its formula uses one of these.