You can build cost calculation formulas to evaluate supplier bids on the Cost Calculation page. Cost calculation formulas are created using arithmetic operators, comparison operators, functions, and bid sheet columns.
Note:
You must create a cost calculation formula before you can publish your event. Ensure that your cost calculation does not evaluate to zero.
- Cost calculation field: Enter your primary cost calculation formula in this field, or else use the buttons in the Formula area to build your formula.
- Display type list: Select which format the result is displayed in: Number or Currency.
- Manage secondary calculations: Click to add and manage additional secondary formulas.
- Formula area: Use the arithmetic operators, comparison operators, function buttons, and bid sheet columns to build your formula.
- Test Calculation area: Enter sample values in the fields and then run a test calculation to test your formula.
Arithmetic operators
Use arithmetic operators to create mathematical expressions in your formula. Table 1 describes the arithmetic operators available for building cost calculation formulas.
Table 1. Arithmetic operators
Operator |
Function |
+ |
Addition |
- |
Subtraction and negation |
* |
Multiplication |
/ |
Division |
( |
Left parenthesis |
) |
Right parenthesis |
Comparison operators
Use comparison operators to compare values in your formula. Table 2 describes the comparison operators available for building cost calculation formulas.
Table 2. Comparison operators
Operator |
Function |
= |
Checks if two values are equal |
> |
Checks if a value is greater than another value |
< |
Checks if a value is less than another value |
>= |
Checks if a value is greater than or equal to another value |
<= |
Checks if a value is less than or equal to another value |
<> |
Checks if two values are not equal to each other |
Functions
Functions are predefined formulas. Table 3 describes the functions available for building cost calculation formulas.
Table 3. Functions
Operator |
Function |
IF() |
Tests for a condition. |
AND() |
Check if all conditions in a test are true. |
OR() |
Check if any conditions in a test are true. |
MIN() |
Returns the smallest number in a set of values. |
MAX() |
Returns the largest number in a set of values |
SUM() |
Adds all of the values in the argument. |
AVERAGE() |
Returns the average of the values in the argument. |
MEDIAN() |
Returns the median of the values in the argument. |
ROUND() |
Rounds a number to a specified number of decimal places. |
ROUNDUP() |
Rounds a number up, always. |
ROUNDDOWN() |
Rounds a number down, always. |
CONCATENATE() |
Joins text strings together into one string. |
BIDDER() |
Returns the bidder organization name. |
ISBLANK() |
Checks if a cell is blank and returns either TRUE or FALSE. |
Bid Sheet Columns
The Bid Sheet Columns area of the Cost Calculation page lists the columns from your bid sheet that you can use to build your cost calculation formula. You can only use bid sheet columns that have been configured as mandatory. Optional columns are not available when configuring a cost calculation.
Note:
Ensure that your cost calculation formula is not configured to equal a text input column.