Dynamic Fields

The rack bay number, from left to right, a product is on. This field calculates "universal" bay based on the horizontal position of each Rack in the planogram.

Even if three separate racks exist, bay values will be assigned 1–3 across all racks, instead of each bay count restarting at 1 for each rack.

This will be 0 if a product is not on a rack. Not to be confused with Bay.

How many units of the product fill its Bin, counting whole units across, up and back.

This is a lower bound: it assumes units sit square and unrotated, so a Bin of loose-filled hardware will hold more than this reports. Treat it as "at least this many".

0 if the product is not merchandised as a Bin. Note this differs from Capacity, which counts how many Bins fit on the fixture front to back.

For the Bin's own dimensions, use Width / Height / Depth: those already report a Position's acting size, which for a Bin IS its bin size.

Returns the index of the container this product is in. If the product's container is on a shelf, the containers on it are ordered from 1 to N, left to right.

If the product's container is parented to a rack, all containers on it are ordered from top left to bottom right, 1 to N.

If the product's container is not on a shelf or a rack, this returns "Not in container".

How many dividers this Bin accounts for.

A Bin is a compartment, so it needs a wall on each side. A run of Bins pushed together shares walls between neighbours and is closed off at both ends, so a run of N takes N + 1 dividers -- and a Bin sitting on its own still takes 2. A shelf whose Bins fall into two separated runs therefore needs more dividers, not fewer.

The count is attributed one Bin at a time (each owns the divider to its left, and whichever Bin ends a run also owns the wall that closes it) so that it adds up: Sum(DividerQty) gives the right total for a shelf, a bay, or a whole plan. For a ready-made order list, see the Fixture BOM report option.

Multiplies FacingsHigh and FacingsWide to get the total number of facings as viewed in XY plane.

Similar to FacingsTotal, but does not include FacingsDeep.

A convenience field that multiplies FacingsWide x FacingsHigh x FacingsDeep to get the total number of facings specified at a position.

Not to be confused with FacingsFront, which just considers FacingsWide x FacingsHigh.

How much lower each prong sits than the one in front of it, in the hook's units.

0 is a level arm, where only the front product is visible head-on. Above 0 is a waterfall, which cascades so every product stays visible.

Centre-to-centre spacing between prongs, along the hook's reach, in the hook's units.

0 means the hook's prongs are just a capacity number. Above 0, each prong is an addressable station that can hold its own SKU, as on a waterfall or straight-arm rack.

Which prong a product position STARTS on, counting from 1 at the prong nearest the fixture.

A position can cover several prongs -- one alone on the arm covers them all, and SKUs sharing an arm divide them between them -- so this is where its run begins, not the only prong it uses. 1 for anything that is not on a pronged hook.

The type of the hook for a pegged product position. Possible values are:

• S - Standard, uses 2 pegholes with the hook between them
• J - Uses a single peghole
• L - Loop hook, wider appearance

Returns which layer a product occupies within its Layered Group, counting from 1 at the end of the group nearest the fixture.

• In a depth-wise group (for example several SKUs sharing one peghook), layer 1 is the layer at the fixture and the highest layer is the one facing the shopper.
• In a stack (for example folded shirts on a table), layer 1 is the bottom of the stack.

A product that is not in a Layered Group returns 1, since it is its own only layer.

To count from the other end instead, use LayerCount - LayerIndex + 1. To report letters rather than numbers, use Format(LayerIndex, A). See also LayerCount.

The current merchandising style of a product position. Typically this is "Default", though any style is possible.

Common examples include Tray, Carton, PDQ, Unit, etc...

For more information on how to set up merch styles, see the catalog format documentation.

A decimal number specifying the horizontal position of the product on its fixture.

For pegboards, this is the number of pegholes from the left edge of the pegboard.

For shelves, this is a unique number, from 1 to N (where N is the number of products / fixture groups on the shelf), from left to right.

For containers, this is the same as ContainerIndex.

For all other fixtures, this is the number of inches / cm across from the left edge of the fixture.

A decimal number specifying the vertical position of the product on its fixture.

For pegboards, this is the number of pegholes down.

For shelves, this is always 0.

For all other fixtures, this is the number of inches / cm down from the top of the fixture.

Returns the index of a product's shelf, from bottom to top (1 to N)

Not to be confused with ShelfIndex, which orders shelves from top to bottom

Returns the total number of top-level items on a product position's shelf.

Not to be confused with ShelfFacingsCount. For example, if a Shelf held a single product position with 2 facings:

• ShelfMemberCount returns 1
• ShelfFacingsCount returns 2

Returns the sum of FacingsWide x FacingsHigh x FacingsDeep across every Position in the entire display.

See also TotalFrontFacings, which ignores FacingsDeep.

Returns the sum of FacingsWide x FacingsHigh across every Position in the entire display. Represents how many product "faces" a shopper would see.

Does not include FacingsDeep. See also TotalFacings.

Legacy synonym for TotalFrontFacings. Kept for backward compatibility; new expressions should use one of TotalPositions, TotalFrontFacings, or TotalFacings to be explicit about what is being counted.