RATIO_MINIMUM

Is the ratio of two fields below the value set by this policy.

Syntax

  "<USER DEFINED LABEL>": {
    "TYPE": "RATIO_MINIMUM,
    "PARAMETERS": "<NUMERATOR FIELD>, <DENOMINATOR FIELD>, <MINIMUM RATIO VALUE>"
  }

Example

This policy definition check if discounts are greater than 40% (i.e the ratio of OFFER PRICE to REGULAR PRICE is less than 0.6)

  "DISCOUNT RATIO": {
    "TYPE": "RATIO_MINIMUM,
    "PARAMETERS": "OFFER PRICE, REGULAR PRICE, 0.6"
  }

See Also

IN SET

Prerequisites

The <NUMERATOR FIELD> and <DENOMINATOR FIELD> specified in the PARAMETERS must be in the file.