Functions Availability in Price Formula

Owned by Guillaume Robitaille
Last updated: Nov 14, 2019
4 min read

All ? in functions below need to be replaced by the right category name when used in a formula

FUNCTIONS

DESCRIPTION

FUNCTIONS

DESCRIPTION

[PRODUCT DETAIL PRICE]

System Parameter that display the default product price

[PRODUCT COST]

System Parameter that display the defaul product cost

[PRODUCT WIDTH]

Parameter that represent the width of the product entered in the quotation if modified, if not it will display the default width of the product

[PRODUCT HEIGHT]

Parameter that represent the heigth of the product entered in the quotation if modified, if not it will display the default heigth of the product

[PRODUCT DEPTH]

Parameter that represent the depth of the product entered in the quotation if modified, if not it will display the default depth of the product

[SQUARE FEET COST - ?]

Feature Parameter that represent the square feet cost entered in the feature

  • For example : [SQUARE FEET COST - CATEGORY X]

Will return the sqare feet cost value of the selected feature from the category named : CATEGORY X

[FIXED COST - ?]

Feature Parameter that represent the fixed cost entered in the feature

  • For example : [FIXED COST - CATEGORY X]

Will return the fixed cost value of the selected feature from the category named : CATEGORY X

[LINEAR COST - ?]

Feature Parameter that represent the linear cost entered in the feature

  • For example : [LINEAR COST - CATEGORY X]

Will return the linear cost value of the selected feature from the category named : CATEGORY X

[SQUARE FEET PRICE - ?]

Feature Parameter that represent the square feet price cost entered in the feature

  • For example : [SQUARE FEET PRICE - CATEGORY X]

Will return the square feet price value of the selected feature from the category named : CATEGORY X

[FIXED PRICE - ?]

Feature Parameter that represent the fixed price cost entered in the feature

  • For example : [FIXED PRICE - CATEGORY X]

Will return the fixed price value of the selected feature from the category named : CATEGORY X

[LINEAR PRICE - ?]

Feature Parameter that represent the linear price cost entered in the feature

  • For example : [LINEAR PRICE - CATEGORY X]

Will return the linear price value of the selected feature from the category named : CATEGORY X

[WIDTH MIN - ?]

Feature Parameter that represent the minimum width entered in the feature

  • For example : [WIDTH MIN - CATEGORY X]

Will return the minimum width value of the selected feature from the category named : CATEGORY X

[WIDTH MAX - ?]

Feature Parameter that represent the maximum width entered in the feature

  • For example : [WIDTH MAX - CATEGORY X]

Will return the maximum width value of the selected feature from the category named : CATEGORY X

[HEIGHT -MIN - ?]

Feature Parameter that represent the minimum height entered in the feature

  • For example : [HEIGHT MIN - CATEGORY X]

Will return the minimum height value of the selected feature from the category named : CATEGORY X

[HEIGHT MAX - ?]

Feature Parameter that represent the maximum height entered in the feature

  • For example : [HEIGHT MAX - CATEGORY X]

Will return the maximum height value of the selected feature from the category named : CATEGORY X

[DEPTH MIN - ?]

Feature Parameter that represent the minimum depth entered in the feature

  • For example : [DEPTH MIN - CATEGORY X]

Will return the minimum depth value of the selected feature from the category named : CATEGORY X

[DEPTH MAX - ?]

Feature Parameter that represent the maximum depth entered in the feature

  • For example : [DEPTH MAX - CATEGORY X]

Will return the maximum depth value of the selected feature from the category named : CATEGORY X

[PRODUCT AREA]

Parameter that return the square feet quantity of the face area of the product

  • this parameter can only be used to get the value of the front area (width x height)

[VALUE - ?]

Parameter that return the manually entered value of a manual category

[NAME - ?]

Parameter that return the name of the selected feature from a specific category

ROUND( ? )

This functions is used to round a value to the nearest integer number

  • For example : ROUND([VALUE - CATEGORY X MANUAL])

This will return the rounded value of the value entered manually in the category when selecting the features

ROUNDUP( ? )

This functions is used to round up a value to the next integer number

  • For example : ROUNDUP([VALUE - CATEGORY X MANUAL])

This will return the round up value of the value entered manually in the category when selecting the features

ROUNDDOWN( ? )

This functions is used to round down a value to the integer number just before

  • For example : ROUNDDOWN([VALUE - CATEGORY X MANUAL])

This will return the round down value of the value entered manually in the category when selecting the features

Â